count the size of array variable
i hv created an array to store multiple data and passing it to sub program thru function.
in that sub program after some validation i hv to insert data from array to a table.now i need to find how many iteration do i need for that array.
Is there any function in oracle which can tell the total number of elements of an Array variable ?
[ name of adt ].count
it returns the array size
This is Oracle we're talking about?
Originally Posted by crysu
Table 5-2 Collection Methods
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.
Returns first subscript in collection.
Returns last subscript in collection.
Returns number of elements in collection.
Returns maximum number of elements that collection can have.
Returns subscript that precedes specified subscript.
Returns subscript that succeeds specified subscript.
Click Here to Expand Forum to Full Width