NVL stand for? I'm talking about the Oracle and Informix (perhaps some others too) function used to filter out non NULL values from query results (similar to
COALESCE in other databases).
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Quite simply: Null VaLue
The function substitutes any NULLs in a given resultset column with the value given as the second parameter.
"Null Value Logic" according to http://www.abbreviations.com/term/157605, but most of the other references I have found support Phil's "Null Value" supposition. I haven't found a definitive origin.