The Oracle NVL2 function

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”