Conversion Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Conversion Functions
  4. NULLIF() compares two expressions If they are equal, it returns NULL Otherwise, it returns the first expression
SQL>
Syntax: NULLIF( ,)
SQL>
SQL> SELECT
  2     NULLIF('ABC','ABC')  equal,
  3     NULLIF ('ABC','DEF') diff from dual;
EQU DIF
--- ---
    ABC