Null Value Compare « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. Null Value Compare
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)




10.null is null