26. 19. 2. IS EMPTY operator checks whether a VARRAY or NESTED TABLE collection variable 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.