AntDB-Oracle Compatibility Developer’s Manual P3–70

NVL

The NVL function returns a non-NULL value from two expressions. If the result of both expr1 and expr2 is a NULL value, the NVL function returns NULL.

NVL(expr1, expr2)

Example:

select NVL(null, 1) from dual;
 NVL(NULL, 1)  
---------------
 1
(1 row)

select NVL(2, null) from dual;
 NVL(2, NULL)  
---------------
 2
(1 row)

select NVL(null, null) from dual;
 NVL(NULL, NULL)  
------------------

(1 row)