Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

Null value compare

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