entered a 30 digit number 123456789012345678901234567890
Interesting puzzle. You didn’t mention which version of Toad you were on. The following is based on my being on Toad 10.6.1.3
I did as you did (perhaps) and created a tmp table with a column of number(38) entering the value identified. The “perhaps” part comes into the picture with regards how I did that. I performed those steps in SQL Plus.
I then entered Toad, made sure the scientific notation was disabled and selected from the table. I got the number exactly as entered.
So… what do you get if you enter the following from SQLPlus:
Select to_char(, ‘99999999999999999999999999999999999999’) from ;
If you get the same truncated result, then John has hit the nail squarely on the head I’m thinking.
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.