I'm exporting a number(22) column to Excel but when the Excel file is launched the number has rounded up e.g.
1234567890123456 becomes 1234567890123460
When exporting the same data from Toad for Oracle, however, the number is not rounded up
Excerpt from release notes:
"Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. "
Toad for Data Analysts exports as a number and, hence, is rounded by Excel. Toad for Oracle appears to export 'number as text' so retains the correct information.
WORKAROUND
Export data as a .csv file
STATUS
Waiting for fix in a future release of Toad for Data Analysts.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center