add NVL2()

nvl2(x,y,z)
Returns the second argument if the first argument is not null, otherwise it returns the third argument.
nvl2 is short hand for the case expression “case when x is not null then y else z end.”

References:
http://docs.oracle.com/database/122/SQLRF/NVL2.htm#SQLRF00685