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