确实40位精度还在,以前在这看到过帖子。
select to_char(to_number(lpad('9',40,'9'))) from dual;
TO_CHAR(TO_NUMBER(LPAD('9',40,'9')))
----------------------------------------
9999999999999999999999999999999999999999
select to_char(to_number(lpad('9',41,'9'))) from dual;
TO_CHAR(TO_NUMBER(LPAD('9',41,'9')))
----------------------------------------
1.0000000000000000000000000000000000E+41
|