15.7.1 nvl(value1, value2)

nvl lets you replace null (returned as a blank) with a value of the same type as the first argument. For example, in a list of employees and commission, you can substitute Not Applicable if the employee receives no commission using the nvl(value1,value2) function as nvl(Not Applicable,Commission).

Example

Function Result

nvl(Not Applicable,Commission)

Not Applicable