using the nvl function : NULL « Data Type « Oracle PL / SQL






using the nvl function

 
SQL> select 12 from dual where nvl(null,'X') = nvl(null,'X');

        12
----------
        12

1 row selected.

SQL>
SQL>
SQL>

 








Related examples in the same category

1.2 meaningless values can't be compared against one another
2.This in the only way to do it properly to get the desired results