Advanced Search

Return to Snippet

Revision: 71756
at March 8, 2017 11:44 by bbrumm
Initial Code 
CREATE TABLE nanvl_test (
num_val NUMBER(10,3),
f_val FLOAT(3),
bf_val BINARY_FLOAT,
bd_val BINARY_DOUBLE);

INSERT INTO nanvl_test (num_val, f_val, bf_val, bd_val)
VALUES (123.456, 234.567, 987.654, 135.789);


INSERT INTO nanvl_test (num_val, f_val, bf_val, bd_val)
VALUES (0, 0, 'NaN', 'NaN');

SELECT num_val, f_val, bf_val, bd_val,
NANVL(num_val, 9999) AS nan_num,
NANVL(f_val, 9999) AS nan_f,
NANVL(bf_val, 9999) AS nan_bf,
NANVL(bd_val, 9999) AS nan_bd
FROM nanvl_test;
Initial URL 
http://www.databasestar.com/oracle-nanvl
Initial Description 
A few examples of the NANVL function.
Initial Title 
Oracle NANVL Function
Initial Tags 
sql, Oracle
Initial Language 
SQL