AntDB-Oracle Compatibility Developer’s Manual P3–69

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)