December 2002
Intermediate to advanced
928 pages
85h 29m
English
You can use the following operators on collections of data in PL/SQL:
Returns count.
Deletes all elements (if no parameters), element n (if only n present), or between element m and n (if both present).
Returns TRUE if element n exists.
Increases the size of a collection.
Returns first element.
Returns last element.
For VARRAYs, returns limit.
Returns next element.
Returns previous element.
Removes n elements from end of collection. If n is not present, removes one element.
For more information about using collections with PL/SQL, see the collection sections in Chapter 9. For more information about creating collection types in the database, see the CREATE TYPE entry in Chapter 7.