Long numbers display in the data grid as scientific notation. How can I have the number display without scientific notation?
1) Select View | Toad Options | Data Grid - Data in Toad's menu bar.
2) Un-check the "Display large numbers in Scientific Notation" option.
3) Open up a new Schema Browser to see the change applied.
If the numbers are still showing as scientific notation in the datagrid of the editor, the width of the number may just be too large for Oracle and the NUMWIDTH settings needs to be adjusted. Please refer to SOL55929 for more info about this.
Note: This issue has been resolved in Toad for Oracle 12.8. Keep in mind to check steps 1,2 and 3 above.