Exporting Oracle Data to Excel
- Execute any SQL query and save the results
directly to an excel spreadsheet.
- Run multiple queries and save the data to a single Excel
spreadsheet, each recordset to its own worksheet.
Exporting Oracle Data to Delimited Files
- Export one table at a time, or...
- Export data from multiple tables at once.
- Export data as csv (just select comma as a the delimiter and give
the file the extension .csv).
- Export data where you have total control over choosing the column
delimiter.
|
Watch these scenarios. They are live demonstrations that take about
a minute each to run.
How
to export many queries to a single spreadsheet?
How to run a
query and send results directly to an excel spreadsheet?
How
to export table data to delimited files?
For Oracle 8i, 9i, and 10g
|
