Return
-
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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.