Oracle NVL Function
Oracle NVL Function: The NVL function allow you to replace null values with a default value. If the first parameter is null, the function returns the second parameter. If the first parameter have some value then always return first value.
Note := NVL function replaces null value with same type data.
Syntax of the …