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;