If value IS NULL, raise exception : IS NULL Value « Data Type « Oracle PL / SQL






If value IS NULL, raise exception

 
SQL>
SQL> DECLARE
  2     lv_general_excep EXCEPTION;
  3  BEGIN
  4     IF NULL IS NULL THEN
  5        RAISE lv_general_excep;
  6     ELSE
  7        -- Process Logic
  8        NULL;
  9     END IF;
 10  EXCEPTION
 11     WHEN lv_general_excep THEN
 12        NULL;
 13  END;
 14  /

PL/SQL procedure successfully completed.

SQL>

 








Related examples in the same category

1.The IS NULL operator in action