COALESCE

COALESCE returns the first non-null expression in a list of expressions, or null when all of the expressions evaluate to null.

Return Value

Data type of the first argument

Syntax

COALESCE(expr [, expr ]...) 

Arguments

expr can be any expression.

Example

COALESCE(5, 8, 3) returns the value 5.

Copyright © 2003, 2007, Oracle. All rights reserved.