NULL and Empty Nested Tables and NULL elements : Table of Number « Collections « Oracle PL/SQL Tutorial

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

SQL> declare
  2
  3    Type numberTableType is TABLE OF NUMBER;
  4
  5    v_numarray numberTableType;
  6
  7  begin
  8
  9    if v_numarray IS NULL then
 10
 11      dbms_output.put_line('v_numarray is null');
 12
 13    end if;
 14
 15    v_numarray :=NULL;
 16
 17    if v_numarray IS NULL then
 18
 19      dbms_output.put_line('v_numarray is null after assignment');
 20
 21    end if;
 22  end;
 23  /
v_numarray is null
v_numarray is null after assignment

PL/SQL procedure successfully completed.

SQL>