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)