Declare a nested table with null values.
SQL>
SQL> DECLARE
2 TYPE charArrayType IS TABLE OF VARCHAR2(5 CHAR);
3
4 charArray charArrayType := charArrayType(NULL,NULL,NULL);
5 BEGIN
6
7 FOR i IN 1..3 LOOP
8 dbms_output.put_line('charArray:'||i||':'||charArray(i));
9 END LOOP;
10 END;
11 /
charArray:1:
charArray:2:
charArray:3:
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category