NVL

NVL(expr1,expr2)

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

See also the IFNULL function.