ORACLE数值类型详解--NUMBER、FLOAT、BINARY_FLOAT、BINARY_DOUBLE、BINARY_INTEGER(四)
----------
1 1.0E+000 1.0E+000
2 Nan Nan
4 -Inf -Inf
SQL> select * from tab1 where c1 = (select c1 from tab1 where id =2);
ID C1 C2
------ ---------- ----------
2 Nan Nan
SQL> select * from tab1 where c1 = nan;
select * from tab1 where c1 = nan
*
第 1 行出现错误:
ORA-00904: "NAN": 标识符无效
SQL> select * from tab1 where c1 = binary_float_nan;
ID C1 C2
------ ---------- ----------
2 Nan Nan
SQL> select * from tab1 where c1 = (select c1 from tab1 where id =3);
ID C1 C2
------ ---------- ----------
3 Inf Inf
SQL>
优先级：在数据转换时，优先转换为高级别的数据类型
date type > binary_double > binary_float > number > char