How to make csv export faster apex oracle without exponential values?

Asked By 20 points N/A Posted on -
qa-featured

How to make csv export faster apex oracle with exponential values? I got large number of data to be downloaded in csv format and its taking rather slow. Long numbers are showing exponential values instead of plain numbers. What can I do to fix that?

SHARE
Best Answer by Runyon Grace
Best Answer
Best Answer
Answered By 0 points N/A #148157

How to make csv export faster apex oracle without exponential values?

qa-featured

There is an alternate. Your all activity could be done by skipping the CSV step. There is an option available in Apex through which you can export the report directly. Second way is to install application express 3.1. It makes easy to store files in the form of table with a BLOB column and you can easily build reports on that tables. Please try to expand your columns or if you are using excel to view file in CSV format select the input method as text because excel has limitation of showing lengthy numbers.

Answered By 0 points N/A #148158

How to make csv export faster apex oracle without exponential values?

qa-featured

 

You can solve the issue of large numbers being displayed in exponential format by putting the numbers in single quotes in the csv. So that Excel  interprets  them as text. So you should be comfortable with Oracle's special handling requirements for including single quotes in a string. And you can also export it directly.

Login/Register to Answer

Related Questions