IS EMPTY operator checks whether a VARRAY or NESTED TABLE collection variable is empty : IS EMPTY « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. IS EMPTY

SQL>
SQL>  DECLARE
  2     TYPE list IS TABLE OF INTEGER;
  3     a LIST := list();
  4   BEGIN
  5     IF a IS EMPTY THEN
  6       dbms_output.put_line('"a" is empty.');
  7     END IF;
  8   END;
  9   /
"a" is empty.

PL/SQL procedure successfully completed.

SQL>