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.

PL/SQL procedure successfully completed.

SQL>

Related examples in the same category

1.	IS A SET operator checks whether a variable is a VARRAY or NESTED TABLE collection variable
2.	IS A SET, table collection
3.	IS EMPTY
4.	IS NULL operator checks whether a variable value is null
5.	If varray is empty

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

Related examples in the same category