NULLIF « Conversion Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Conversion Functions
  3. NULLIF
1.NULLIF() compares two expressions. If they are equal, it returns NULL. Otherwise, it returns the first expression.
2.select nullif( 1, 1 )
3.select nullif( 1, null )