Overview
Grammar | NVL(value1,value2,value3,...) | Returns the first non-null value among all parameters.  Note: |
Parameter 1 | value | value 1: can be any number or null. value 2: any number or null. If a character string is of zero length, null is also returned. |
Notes
The function supports at least one parameter(s) of the same type.
Example
| Formula | Result | Notes |
|---|---|---|
| NVL(12,20) | 12 | |
| NVL(null,12) | 12 | |
| NVL(null,null) | null | |
| NVL(20,null) | 20 | |
| NVL(null,null,10) | 10 |
