Collection Methods

are  EXISTS,COUNT, LIMIT, FIRST, LAST, PRIOR, NEXT, EXTEND, TRIM, and DELETE.

We cannot use collection methods in a SQL statement.

FIRST AND LAST[example]

declare

        type months is varray(13) of VARCHAR2(20);

        mon months;

    begin

        mon:=months('jan','feb','mar','apr','may','jun','jul');

        for i in mon.first..mon.last

       loop

           DBMS_OUTPUT.put_line(mon(i));

       end loop;

   end;

OUTPUT

jan

feb

mar

apr

may

jun

jul