Example 2-20 Initialization of Variables and Constants

DECLARE
   counter INTEGER;
BEGIN
-- COUNTER is initially NULL, so 'COUNTER + 1' is also null.
   counter := counter + 1;
   IF counter IS NULL THEN
      DBMS_OUTPUT.PUT_LINE('COUNTER is NULL not 1.');
   END IF;
END;
/

Example 2-20 Initialization of Variables and Constants

DECLARE
   counter INTEGER;
BEGIN
-- COUNTER is initially NULL, so 'COUNTER + 1' is also null.
   counter := counter + 1;
   IF counter IS NULL THEN
      DBMS_OUTPUT.PUT_LINE('COUNTER is NULL not 1.');
   END IF;
END;
/