Numbers displayed in scientific notation even when option is disabled. (4317126)

Large numbers are displayed in scientific notation in the data grid, even when the "Display large numbers in Scientific Notation" Toad option is disabled.

The width of the number may just be too large for Oracle and the NUMWIDTH settings needs to be adjusted. Oracle defaults NUMWIDTH to 10. If you number is large than 10 (i.e. 456456456456) then Oracle will display in Scientific notation, despite Toad's settings.

WORKAROUND 1:

To adjust the NUMWIDTH, set it to something larger than 10 that will fit the largest number you wish to display in full.

SET NUMWIDTH <#>;

(i.e. SET NUMWIDTH 15;)

This will need to be set per session since running a SET command will only apply to the session you're working in.

If you would like to set this more permanently you can add the command to your Oracle scripts that will run on connection and it will apply to your full connection. This means editing your glogin.sql or login.sql files. Find your glogin or login files and add this command.

Some things to keep in mind:

1. These files apply to the Oracle connection and your client so it can affect other applications to, not limited to Toad.
2. When connecting to the database in Toad, make sure to use the client that access the specific glogin/login files you add this command to. If you have multiple clients you wish to use, you may want to make this adjusted to all these scripts associated to your various clients.
3. If you are using an instant client, there are no scripts and the SET will need to be run each time before running the query in the editor.

WORKAROUND 2:

 This situation is easier to handle with Toad for Oracle 12.8

Please note queries can be executed by either F5 execute as script, or F9 run as statement. F5 more closely resembles script output and SQL Plus. F9 will apply Toad option settings. Display in full number may not be an issue if run by F9. But note, F9 will only run one query/statement at a time.