Infinity in Oracle

SQL> create table t_i (id binary_float);

Table created.

SQL> alter table t_i add (name varchar(3));

Table altered.

SQL> select * from t_i where id is nan;

no rows selected

SQL> insert into t_i values(binary_float_infinity, null);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t_i where id is infinite;

ID NAM
---------- ---
Inf

SQL> insert into t_i values(binary_float_nan, null);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t_i where id is nan;

ID NAM
---------- ---
Nan