Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What does 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).

share|improve this question
1  
An interesting comparison of NVL and COALESCE in Oracle: stackoverflow.com/questions/950084/… –  FrustratedWithFormsDesigner Apr 12 '12 at 15:13
4  
"There is a story here, but I don't remember the names of the X3H2 [SQL standard] Committee members involved. We came up with this function because everyone had an NVL() or IFNULL() or something in their product and we wanted a standard syntax for it. Someone else generalized it to a list, but nobody coudl come up with a name we all liked... someone pulled out a Thesaurus and started looking for a single word that nobody would use for a table name, column name or other function and that was not used in any existing product. You know who the winner was now [i.e. COALESCE]" -- Joe Celko. –  onedaywhen Apr 13 '12 at 10:10
add comment

3 Answers

up vote 7 down vote accepted

Quite simply: Null VaLue

The function substitutes any NULLs in a given resultset column with the value given as the second parameter.

share|improve this answer
    
OK, I was expecting something more interesting, like Null Value Limiter. –  newenglander Apr 12 '12 at 15:19
3  
Null Value Llama would be more interesting :) –  FreshPhilOfSO Apr 12 '12 at 15:20
1  
...or Noogie Volcano Lungfish... –  FrustratedWithFormsDesigner Apr 12 '12 at 16:13
2  
Do you have a citation for this or are you merely guessing? –  onedaywhen Apr 13 '12 at 9:48
    
show 1 more comment

"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.

share|improve this answer
add comment

NVL Stands for Null Value Locator

share|improve this answer
1  
Please support your answer with documentation. –  Chris Aldrich Oct 21 '13 at 16:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.