Monthly Archives: May 2014

The COALESCE Function

Everybody knows the NVL function, and use it frequently. On the other hand, the COALESCE function, which belongs to the same family of functions, is less known, although it exists since version 9i and has more capabilities than the good old NVL. Let’s start with the similarities between these functions: What? Both functions have a […]

Continue reading