Collections Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Collections
  4. 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>