nvl(value1, value2) If value1 is not null then return value1, otherwise return value2. Examplevalue = nvl(null,999)