SQL> create table t(i BINARY_DOUBLE);表已创建。SQL> insert into t values(1);已创建 1 行。SQL> insert into t values('INF');已创建 1 行。SQL> select * from t; I ---------- 1.0E+000 InfSQL> select * from t where i is infinity; select * from t where i is infinity * 第 1 行出现错误: ORA-00908: 缺失 NULL 关键字 SQL> select * from t where i IS INFINITE; I ---------- Inf
----------
1.0E+000
InfSQL> select * from t where i is infinity;
select * from t where i is infinity
*
第 1 行出现错误:
ORA-00908: 缺失 NULL 关键字
SQL> select * from t where i IS INFINITE; I
----------
Inf