I recently wrote about NVL2. A function much like NVL2 is coalesce.

Coalesce is of the format COALESCE(expr1, expr2, exprN…)

Coalesce returns the first non-null expression in the expression list.

Coalesce is different from most SQL functions in that it allows a varying number of expressions.

Coalesce is basically a big IF statement:

Read the rest of this post.