Toad truncates / rounds large Oracle numbers?

Question

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 select:

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

Question: why does TOAD trim the result when displaying the NUMBER field (20.7)? Obviously, the data is printed there using to_char.

??

Answer 1

Toad limits the number in the data grid to 15 digits. I believe this is due to the fact that the number of excel constraints is 15 digits (or is used to limit them). You can enable “scientific notation” in options → data grids → data, the Show large numbers in scientific notation check box. This will not help either.

Answer 2

→ Right click in the data grid

→ Select " Grid Options... "

→ In the " Data Grids " section, " Data Grids " is selected

→ Uncheck " Display large numbers in Scientific Notation "

After that, you need to close and open TOAD again. This worked for me in TOAD Version 8.6.0.38

Answer 3

I had a similar problem, the Toad truncated / rounded my numbers when displayed in a grid.

I found out that using the Run Expression button or pressing F9 to execute the query, trimming / rounding will not be performed.

I hope this helps.