nvl(value1, value2)

If value1 is not null then return value1, otherwise return value2.

Example

value = nvl(null,999)