Mega Code Archive
An example of the FIRST, LAST and NEXT methods
<![CDATA[
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.
]]>