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
Product defect.
WORKAROUND
Use F9 (run as a statement) to execute the script.
STATUS
Waiting for a fix in a future release of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy