where null <> null : IS NULL « Query Select « Oracle PL/SQL Tutorial






SQL>
SQL> select * from dual where null <> null;

no rows selected

SQL>








2.24.IS NULL
2.24.1.IS NULL clause
2.24.2.If value is null or less than a value
2.24.3.If the value is not null
2.24.4.where null <> null
2.24.5.where null=null (equals)