Oracle in a Nutshell

Collection Operators

You can use the following operators on collections of data in PL/SQL:

COUNT

Returns count.

DELETE[([ m,] n )]

Deletes all elements (if no parameters), element n (if only n present), or between element m and n (if both present).

EXISTS( n )

Returns TRUE if element n exists.

EXTEND

Increases the size of a collection.

FIRST

Returns first element.

LAST

Returns last element.

LIMIT

For VARRAYs, returns limit.

NEXT

Returns next element.

PRIOR

Returns previous element.

TRIM[( n )]

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.