NVL

From Wikipedia, the free encyclopedia

This article is about the computer-related function. For the Connecticut high school athletic conference, see Naugatuck Valley League.

In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.

The syntax for the NVL function is:

NVL( string1, replace_with )

string1 is the string to test for a null value.

replace_with is the value returned if string1 is null.

[edit] See Also

 This computer storage-related article is a stub. You can help Wikipedia by expanding it.