Oracle Database Handling NULL values NVL2 to get a different result if a value is null or not
Example
If the first parameter is NOT NULL, NVL2 will return the second parameter. Otherwise it will return the third one.
SELECT NVL2(null, 'Foo', 'Bar'), NVL2(5, 'Foo', 'Bar') FROM DUAL;
| NVL2(NULL,'FOO','BAR') | NVL2(5,'FOO','BAR') |
|---|---|
| Bar | Foo |
