Originally Posted by
crysu
length
it returns the array size
This is Oracle we're talking about?
Code:
Table 5-2 Collection Methods
Method Type
Description
DELETE Procedure Deletes elements from collection.
TRIM Procedure Deletes elements from end of varray or nested table.
EXTEND Procedure Adds elements to end of varray or nested table.
EXISTS Function Returns TRUE if and only if specified element of varray or nested table exists.
FIRST Function
Returns first subscript in collection.
LAST Function
Returns last subscript in collection.
COUNT Function
Returns number of elements in collection.
LIMIT Function
Returns maximum number of elements that collection can have.
PRIOR Function
Returns subscript that precedes specified subscript.
NEXT Function
Returns subscript that succeeds specified subscript.
Reply With Quote