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





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

1.select coalesce( null, '', 'A' )
2.select coalesce( null, sysdate )