Null Value Compare « Select Query « Oracle PL / SQL






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