Mega Code Archive

 

Categories / Oracle PLSQL / Conversion Functions

 

COALESCE() returns the first non-null expression in the expression list

Syntax: COALESCE (<exp1>,<exp2> . . . <expN>) SQL> SQL> SELECT COALESCE (NULL, NULL, 'NOT NULL', NULL) test from dual; TEST -------- NOT NULL SQL> SQL>