DECLARE
TYPE t IS TABLE OF INTEGER
INDEX BY VARCHAR2 (3);
tt t;
BEGIN
FOR indx IN 1 .. 10
LOOP
tt (indx) := 100;
END LOOP;
DBMS_OUTPUT.put_line (tt.COUNT);
DBMS_OUTPUT.put_line (tt.FIRST);
DBMS_OUTPUT.put_line (tt.LAST);
END;
Statement processed.
10
1
9
DECLARE
TYPE t IS TABLE OF INTEGER
INDEX BY VARCHAR2 (3);
tt t;
l_index VARCHAR2 (3);
BEGIN
FOR indx IN 1 .. 10
LOOP
tt (indx) := 100;
END LOOP;
l_index := tt.FIRST;
WHILE l_index IS NOT NULL
LOOP
DBMS_OUTPUT.put_line (l_index);
l_index := tt.NEXT (l_index);
END LOOP;
END;
Statement processed.
1
10
2
3
4
5
6
7
8
9