NVL2

Use NVL2 to evaluate an expression and determine if the value is null or not null. Define a substitute value for a not null condition and a substitute value for a null result. The first parameter is the expression, the second parameter is the substitute value for a not null condition. The third parameter is the substitute for a null condition. The second and third parameters must be the same data type.