Collection Methods - Actions

EXISTS(n)       :  Returns TRUE if nth element of the table exists.

COUNT            :  The number of elements (rows) in the plsql table

               

FIRST             :  First and Last index no.s in the table

LAST                    Returns NULL if table is empty

               

PRIOR(n)         :  Returns index no that preceeds n in the plsql table

               

NEXT(n)          :  Returns index no that succeeds n in the plsql table

               

EXTEND(n,i)     :  Append n copies of the 'i'th element to a plsql table

                         i defaults to NULL n defaults to 1

               

TRIM(n)           :  Remove n elements from the end of a plsql table

                         n defaults to 1

                

DELETE(m,n)    :  Delete elements in range m...n

                         m defaults to = n

                         n  defaults to ALL elements