蟾蜍将大Oracle号截断/舍入吗? [英] Toad truncating/rounding large Oracle numbers?

问题描述

我们有一个表，其中的'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.

这篇关于蟾蜍将大Oracle号截断/舍入吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！