null is null : Null Value Compare « Select Query « Oracle PL / SQL






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

null is null

 

SQL> select * from dual where null is null;

D
-
X

1 row selected.








Related examples in the same category

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