Saturday, March 30, 2013

Comparison of PL/SQL COLLECTIONS - III

NAME VARRAY NESTED TABLE ASSOCIATIVE ARRAY
TRIM
Removes one element from last
in a collection
v1.TRIM v1.TRIM NA
TRIM(n)
Removes n elements from last
in a collection
v1.TRIM(3) v1.TRIM(3) NA
DELETE
Deletes all the elements
in a collection
v1.DELETE v1.DELETE v1.DELETE
DELETE(n)
Deletes elements at index n
in a collection
NA v1.DELETE(6) v1.DELETE(6)
DELETE(m,n)
Deletes all the elements
between m and n indexes
in a collection
NA v1.DELETE(4,7) v1.DELETE(4,7)

No comments:

Post a Comment