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

1  NVL2 ( 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