NVL

NVL(expr1,expr2)
Returns expr2 if expr1 is NULL; otherwise, it returns expr1.

See also the IFNULL function.