Toad truncating/rounding large Oracle numbers?

oracle numbers toad
Marcus Leon picture Marcus Leon · Aug 3, 2010 · Viewed 15.3k times · Source

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

update mytable set price = 1234567890123.1234567;

Then I do this select:

select price, to_char(price) from mytable

PRICE              TO_CHAR(PRICE)
1234567890123.12   "1234567890123.1234567"

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.

??

Answer

René Nyffenegger picture René Nyffenegger · Jan 6, 2011

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.

Related questions

oracle varchar to number

How do i convert a oracle varchar value to number eg table - exception exception_value 555 where exception_value is a varchar type I would like to test the value of exception_value column select * from exception where exception_value = 105 …

Read More
Why do i get #### in the NUMBER column after format... Oracle?

I have two problematic columns: Fee NUMBER type, AdjFee also NUMBER. After column Fee format a5; select Fee ID smth from Visit; i get Fee ID smth #### 123 klkl #### 654 rfjgr

Read More
Oracle NUMBER(p) storage size?

I've searched for it but i can't find a conclusive answer to my question... I need to know what is the storage size of a number(p) field in Oracle. Examples: NUMBER(1), NUMBER(3), NUMBER(8), NUMBER(10) etc...

Read More