Null value compare : Null Value Compare « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. Null Value Compare

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>








Related examples in the same category

1.= NULL or is NULL
2.is null
3.Using the IS NULL operator
4.IS NULL with NOT operator
5.where null <> null
6.where null=null (does null equal null)
7.Convert null number column to 0
8.Not empty(null)
9.null is null