NVL2 Function

Returns the second argument when the first argument is not NULL. If the first argument is NULL, the third argument is returned.

NVL2 Function
Read syntax diagramSkip visual syntax diagramNVL2(expression,result-expression,else-expression )

The NVL2 function is a synonym for the following code:

CASE WHEN expression IS NOT NULL
     THEN result-expression
     ELSE else-expression