How to store table data in a tab separated file in oracle apex ?
Suppose i have a table 'Table1' as shown below.
I want to get the result 'select * from table1;' into a tab separated file in oracle apex.
Would you like the file to live on your server or client machine?
If server, then plenty of options, all typically revolving around UTL_FILE
If client machine, that's a different kettle of fish...
For client you could
- invoke call to Oracle Reports, where an .rdf is ready to generate one for you
- utilise download as csv option in interactive reports
- call page that generates csv using htp package (CSV Download without Header, possible?
- modify an interactive report to do a similar thing (http://www.talkapex.com/2009/04/custom-download-for-apex-interactive.html)