Oracle PL/SQL - Check if parameter is NULL

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Data Type
  4. Associative Arrays

Description

Check if parameter is NULL

Demo

SQL>
SQL> CREATE OR REPLACE PROCEDURE print (n INTEGER) IS
  2  BEGIN-- from w  w w . jav  a2  s  .c o m
  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