If varray is empty : IS « PL SQL « Oracle PL / SQL

If varray is empty

 

SQL> CREATE OR REPLACE TYPE list IS TABLE OF NUMBER;
  2  /

Type created.

SQL>
SQL> CREATE OR REPLACE FUNCTION format_list(set_in LIST) RETURN VARCHAR2 IS
  2    returnValue VARCHAR2(2000);
  3  BEGIN
  4    IF set_in IS EMPTY THEN
  5      dbms_output.put_line('Empty');
  6    END IF;
  7    RETURN returnValue;
  8  END format_list;
  9  /

Function created.

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