NVL

A function in Oracle SQL called like NVL(X, Y) that returns X unless it is null, in which case it returns Y. This function is useful for supplying a default value where an expression might be null.