NVL
Use NVL to evaluate an expression and return a substitute value if the expression is NULL. The first parameter is the expression. The second parameter is the substitute value.
Syntax
NVL(expression, substitute_value)Use NVL to evaluate an expression and return a substitute value if the expression is NULL. The first parameter is the expression. The second parameter is the substitute value.
NVL(expression, substitute_value)