NVL(expr1,expr2)
Returns expr2 if expr1 is NULL; otherwise, it returns expr1.
See also the IFNULL function.