蟾蜍将大Oracle号截断/舍入吗?

本文介绍了蟾蜍将大Oracle号截断/舍入吗?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我们有一个表，其中的'price'字段类型为NUMBER(20,7).在TOAD中，我这样做:

We have a table with a 'price' field of type NUMBER(20,7).. In TOAD I do this:

update mytable set price = 1234567890123.1234567;

然后我选择:

select price, to_char(price) from mytable PRICE TO_CHAR(PRICE) 1234567890123.12 "1234567890123.1234567"

问题是，为什么TOAD在显示NUMBER(20,7)字段时会截断结果?显然，数据在那里，因为它用to_char打印出来.

Question is, why does TOAD truncate the result when displaying the NUMBER(20,7) field? The data is obviously there as it prints out with to_char.

??

推荐答案

Toad将数据网格中的数字限制为15位数字.我相信这是因为excel也将数字限制为15位(或用来限制它们).您可以在选项->数据网格->数据中打开科学计数法"，然后选中以科学计数法显示大量数字.可能也无济于事.

Toad limits numbers in the data grid to 15 digits. I believe this is because excel limits numbers to 15 digits as well (or used to limit them). You can turn on "scientific notation" in options -> data grids -> data, check box Display large numbers in scientific notation. That won't probably help, either.