NULLIF() compares two expressions. If they are equal, it returns NULL. Otherwise, it returns the first expression. : NULLIF « Conversion Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Conversion Functions
3. NULLIF

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

 
SQL>
Syntax: NULLIF( <expression1>,<expression2>)
SQL>
SQL> SELECT
  2     NULLIF('ABC','ABC')  equal,
  3     NULLIF ('ABC','DEF') diff from dual;

EQU DIF
--- ---
    ABC

 

Related examples in the same category