PL/SQL Coalesce
Oracle PL/SQL Coalesce Function
The Coalesce function returns the first non-null expression in the list.
The Coalesce Function syntax:
coalesce( exp1, exp2, … exp_n )
Example:
SELECT coalesce( phone, email, address ) FROM customers;
The Coalesce function returns the first non-null expression in the list.
The Coalesce Function syntax:
coalesce( exp1, exp2, … exp_n )
SELECT coalesce( phone, email, address ) FROM customers;