IS EMPTY : IS « PL SQL « Oracle PL / SQL

IS EMPTY

 


SQL> CREATE OR REPLACE PROCEDURE is_empty_example AS
  2    TYPE charTable IS TABLE OF VARCHAR2(10);
  3    emp1 charTable;
  4    result BOOLEAN;
  5  BEGIN
  6    emp1 := charTable('A', 'B', 'C');
  7    result := emp1 IS EMPTY;
  8    IF result THEN
  9      DBMS_OUTPUT.PUT_LINE('Nested table is empty');
 10    ELSE
 11      DBMS_OUTPUT.PUT_LINE('Nested table contains elements');
 12    END IF;
 13  END is_empty_example;
 14  /

Procedure created.

SQL>
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 operator checks whether a VARRAY or NESTED TABLE collection variable is empty
4.	IS NULL operator checks whether a variable value is null
5.	If varray is empty