Data Management

Mini-Tip #5: Coalesce()

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.

Editor's Picks

Free Newsletters, In your Inbox