Return
-
Title
BINARY_DOUBLE datatype not displaying correctly in Data Grid when using F5 (run as script) -
Description
BINARY_DOUBLE datatype not displaying correctly in Data Grid when using F5 (run as script)
select to_binary_double(6.86163650264137E20) B from dual;
returns
B
----------
6.86163650
1 row selected.Whereas in SQL*Plus we get
B
---------------
6.862E+020 -
Cause
Product defect.
-
Resolution
WORKAROUND
Use F9 (run as a statement) to execute the script.
STATUS
Waiting for a fix in a future release of Toad for Oracle.
-
Defect ID
ST96548