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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center