COALESCE() returns the first non-null expression in the expression list : COALESCE « Conversion Functions « Oracle PL / SQL

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

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>

 

Related examples in the same category