The NVL function lets you substitutes a non-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
Oracle Home
For Everything Oracle and more