using the nvl function
SQL> select 12 from dual where nvl(null,'X') = nvl(null,'X'); 12 ---------- 12 1 row selected. SQL> SQL> SQL>