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) 
Top comments (0)