[Oracle] NANVL()

오라클 NANVL()

 

NANVL()

   -

 

NANVL(n2 ,n1)

의 형태

 

The NANVL function is useful only for floating-point numbers of type BINARY_FLOAT or BINARY_DOUBLE. it instructs Oracle Database to return an alternative value n1 if the input value n2 is NAN(not a number). If n2 is not NaN. then Oracle returns n2.

 

This function takes as arguments any numeric data type or any nonumeric data type that can be implicitly converted to a numeric data type. Oracle determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that data type, and returns that data type.