Thursday, February 3, 2011

Collection

Internal components of the collection are called elements. Each element of the collection can be access by using unique subscripts. To create a collection type it is necessary to define a collection type and then create a variable of that type.
There are three types of collections
1.       Associated Array ( index-by table/ PL/SQL table ) à An unbounded collection
2.       VARRAY ( variable size array) à Bounded collection
3.       Nested table à Unbounded collection

No comments:

Post a Comment

External Table

Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...