SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 a INTEGER;
3 b BOOLEAN;
4 n INTEGER; --this will be our null value.
5 BEGIN
6 a := 2;
7
8 --TRUE and NULL = NULL
9 IF (a = 2) AND (a <> n) THEN
10 DBMS_OUTPUT.PUT_LINE('TRUE and NULL = TRUE');
11 ELSE
12 DBMS_OUTPUT.PUT_LINE('TRUE and NULL = NULL');
13 END IF;
14 END;
15 /
TRUE and NULL = NULL
PL/SQL procedure successfully completed.
SQL>