number_list.EXTEND(2): Add two null value members at the end of the list. : Table of Number « Collections « Oracle PL/SQL Tutorial

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

SQL> create or replace TYPE number_table IS TABLE OF INTEGER;
  2  /

Type created.

SQL> create or replace PROCEDURE print_list(list_in NUMBER_TABLE) IS
  2   BEGIN
  3       FOR i IN list_in.FIRST..list_in.LAST LOOP
  4         IF list_in.EXISTS(i) THEN
  5           DBMS_OUTPUT.PUT_LINE('List '||list_in(i));
  6         END IF;
  7       END LOOP;
  8   END print_list;
  9   /

Procedure created.

SQL>
SQL>
SQL>
SQL> DECLARE
  2     number_list NUMBER_TABLE;
  3
  4   BEGIN
  5     IF NOT number_list.EXISTS(1) THEN
  6       number_list := number_table(1,2,3,4,5);
  7     END IF;
  8
  9     print_list(number_list);
 10
 11     -- Add two null value members at the end of the list.
 12     number_list.EXTEND(2);
 13
 14     -- Print revised contents.
 15     DBMS_OUTPUT.PUT_LINE(CHR(10)||'Nested table after a deletion');
 16     print_list(number_list);
 17   END;
 18   /
List 1
List 2
List 3
List 4
List 5

Nested table after a deletion
List 1
List 2
List 3
List 4
List 5
List
List

PL/SQL procedure successfully completed.

SQL>
SQL>