问题描述
我们有一个表，其中的'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号截断/舍入吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！