NANVL
nanvl(n1,n2) ---- returns n2 if n1 is NaN, otherwise returns n1. Requires that both n1 and n2 be of type numeric or can be implicitly converted to a numeric type.
Example:
select nanvl('NaN',-1) from dual;
NANVL('NAN',-1)
-----------------------
-1
(1 row)
select nanvl(2,-1) from dual;
NANVL(2,-1)
---------------------
2
(1 row)
Top comments (0)