numwidth 对 to_number( ) 的约束

最新推荐文章于 2021-04-06 13:50:03 发布

cobraqing7177

最新推荐文章于 2021-04-06 13:50:03 发布

阅读量433

点赞数

SQL> SELECT to_number('1.99999999999999',9999999.99999999999999999999) from dual;

TO_NUMBER('1.99999999999999',9999999.99999999999999999999)
----------------------------------------------------------
2

SQL> set numwidth 10
SQL> SELECT to_number('1.99999999999999',9999999.99999999999999999999) from dual;

TO_NUMBER('1.99999999999999',9999999.99999999999999999999)
----------------------------------------------------------
2

SQL> SELECT to_number('1.99999999',9999999.99999999999999999999) from dual;

TO_NUMBER('1.99999999',9999999.99999999999999999999)
----------------------------------------------------
1.99999999

SQL> SELECT to_number('1.999999999',9999999.99999999999999999999) from dual;

TO_NUMBER('1.999999999',9999999.99999999999999999999)
-----------------------------------------------------
2

SQL> set numwidth 15
SQL> SELECT to_number('1.999999999',9999999.99999999999999999999) from dual;

TO_NUMBER('1.999999999',9999999.99999999999999999999)
-----------------------------------------------------
1.999999999

SQL> SELECT to_number('1.9999999999999',9999999.99999999999999999999) from dual;

TO_NUMBER('1.9999999999999',9999999.99999999999999999999)
---------------------------------------------------------
1.9999999999999

SQL> SELECT to_number('1.99999999999999',9999999.99999999999999999999) from dual;

TO_NUMBER('1.99999999999999',9999999.99999999999999999999)
----------------------------------------------------------
2

SQL> spool off

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/593324/viewspace-376147/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/593324/viewspace-376147/

关注