Scientific notation is shown where there are long numbers, even though the "Display large numbers in Scientific Notation" option under View | Options | Data Grids | Data is unchecked.
STATUS:
This issue was fixed in Toad 8.5.3.2. The latest version of Toad for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp.
RESOLUTION:
Restart Toad for Oracle after options are set and saved.
Make sure you're running a current version of the Oracle client. Try to match the client version with the database version.
If you're trying to display very large numbers, you may need to change your Oracle SET NUMWIDTH parameter.
1. Launch Toad.
2. Connect to your database.
3. Select View | Options. On the left select SQL Editor. On the right, uncheck "Restore SET defaults prior to script execution."
4. Select APPLY and OK.
5. Type execute the following into your SQL Editor: set numwidth 10;
You can have your DBA permanently set the default numwidth size in your Oracle login scripts.
