插入64位数字时可以将数字转化为字符串再用to_number('number')插入数据库
1.0000E+15只是数据的显示形式
数据库中真正存储的就是999999999999999.99
SQL> select to_char(num) from test_num;
TO_CHAR(NUM)
----------------------------------------
999999999999999.99
或者:
SQL> col num for 99999999999999999999.99
SQL> select num from test_num;
NUM
----------------------------
999999999999999.99