IS NULL operator checks whether a variable value is null : IS « PL SQL « Oracle PL / SQL






IS NULL operator checks whether a variable value is null

 

SQL>
SQL>  DECLARE
  2     var BOOLEAN;
  3    BEGIN
  4     IF var IS NULL THEN
  5      dbms_output.put_line('It is null.');
  6     END IF;
  7    END;
  8    /
It is null.

PL/SQL procedure successfully completed.

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