An example of the FIRST, LAST and NEXT methods : Table of Number « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Table of Number

SQL> DECLARE
  2    TYPE numberTabletype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3    myTable numberTabletype;
  4    idx BINARY_INTEGER;
  5  BEGIN
  6    FOR idx IN 1..10 LOOP
  7      myTable(idx):=(2**idx)+1;
  8    END LOOP;
  9
 10    idx :=myTable.FIRST;
 11
 12    LOOP
 13      dbms_output.put_line(to_char(myTable(idx)));
 14      EXIT WHEN idx =myTable.LAST;
 15      idx :=myTable.NEXT(idx);
 16    END LOOP;
 17  END;
 18  /
3
5
9
17
33
65
129
257
513
1025

PL/SQL procedure successfully completed.