Oracle PL/SQL - Check if parameter is NULL

Description

Check if parameter is NULL

Demo

SQL>
SQL> CREATE OR REPLACE PROCEDURE print (n INTEGER) IS
  2  BEGIN--   ww  w.  ja  v  a2 s  .  c om
  3    IF n IS NOT NULL THEN
  4      DBMS_OUTPUT.PUT_LINE(n);
  5    ELSE
  6      DBMS_OUTPUT.PUT_LINE('NULL');
  7    END IF;
  8  END print;
  9  /

Procedure created.

SQL>

Related Topic