Category: Oracle

NVL2 provides a similar functionality as NVL function.
This function evaluates a column or expression in the following way:

• If the result is not NULL, it returns the second parameter that was given to NVL2 function.
• If the result is NULL, it returns the third parameter that was given to NVL2.

Continue reading “The Oracle NVL2 function”

The NVL function evaluates a column or an expression this way:

• If it’s not NULL, it returns the evaluated value.
• If it’s NULL, it returns the indicated value in the second parameter of NVL.

Continue reading “The Oracle NVL function”