A nested table of a scalar variable:
SQL>
SQL> DECLARE
2 TYPE number_table IS TABLE OF NUMBER;
3 list NUMBER_TABLE := number_table(1,2,3,4,5,6,7,8);
4 BEGIN
5 list.DELETE(2);
6 FOR i IN 1..list.COUNT LOOP
7 IF list.EXISTS(i) THEN
8 dbms_output.put('['||list(i)||']');
9 END IF;
10 END LOOP;
11 dbms_output.new_line;
12 END;
13 /
[1][3][4][5][6][7]
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category