select nullif( 1, null ) : NULLIF « Conversion Functions « Oracle PL / SQL






select nullif( 1, null )

 
SQL>
SQL> select nullif( 1, null )
  2  from dual;
NULLIF(1,NULL)
--------------
             1

1 row selected.

SQL>
SQL>
SQL> --

 








Related examples in the same category

1.NULLIF() compares two expressions. If they are equal, it returns NULL. Otherwise, it returns the first expression.
2.select nullif( 1, 1 )