The NVL function evaluates a column or an expression this way:
- If it’s not NULL, it returns the evaluated value.
- If it’s NULL, it returns the indicated value in the second parameter of NVL.
The NVL function evaluates a column or an expression this way: