-
Title
Results Rounded Up in the Data Grid After Running a Statement in the SQL Editor Window -
Description
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. -
Resolution
RESOLUTION 1:
Go to View | Options | Data Grids | Data & uncheck "Display large numbers in Scientific Notation."
RESOLUTION 2:
Upgrade Oracle Client to 8i or higher.
RESOLUTION 3:
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