Returns a non-null value from two expressions.
Syntax
NVL(eExpression1, eExpression2)
Returns
Character, Date, DateTime, Numeric, Currency, Logical, or the null value
Arguments
eExpression1, eExpression2
NVL( ) returns eExpression2 if eExpression1 evaluates to a null value. NVL( ) returns eExpression1 if eExpression1 is not a null value. eExpression1 and eExpression2 may be any data type. NVL( ) returns .NULL. if both eExpression1 and eExpression2 both evaluate to the null value.
Remarks
Use NVL( ) to remove null values from calculations or operations where null values are not supported or are not relevant.