SQL> select * from dual where ''=null; no rows selected SQL> select * from dual where '' is null; D - X SQL>