Oracle NVL2 Function

The Oracle NVL2 function is an extension of the NVL function and can be used to handle NULL values.

It allows you to specify a value to check for NULL, a separate value to return if the value is NULL, and another value to return if the first value is not NULL. It’s very similar to NVL but allows for more flexibility.