OracleNumeric FunctionsNANVL
LEAST

NANVLNumeric Functions

SIN

Returns a replacement value if the input is NaN.

Syntax

NANVL(n, replacement)

Example

Enter values below to update the example in real time.

col_value
safe_value
metrics
SELECT NANVL(col_value, 0) AS safe_value FROM metrics;