What is NVL function?

Answer

Oracle deals with Null values using NVL function. The function replaces the NULL value in the given column with the value provide to it. The function accepts two parameters, the first one is the column name and the second one is the value with which NULL has to be replaced.

Example

Select Amount – NVL(Disc, 0) from Price