When using an Oracle 8.0.6 Client and connecting to an Oracle 9.2 or higher database, TOAD will return results that are rounded to one decimal position even though the following option is checked:
View | Options | Data Grids | Data | "Display large numbers in Scientific notation."
Take the following query as an example:
SELECT 23 / 13 FROM DUAL;
With the option to display scientific notations enabled, TOAD will return 1.8 instead of the expected result of 1.76923076923077.
Go to View | Options | Data Grids | Data & uncheck "Display large numbers in Scientific Notation."
Upgrade Oracle Client to 8i or higher.
Add the following SET command to the Editor and run query as a script or add the command to the Oracle login script file:
SET NUMWIDTH [n]; ---> where n=2..50