Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to write a SQL query to automatically save the extracted data in a Excel file?

11ce70fa-ab82-4717-9a5c-d3e8382a3cb4Aug 4 2015 — edited Aug 5 2015

Is there a statement that can export data to an Excel file in SQL Developer?

For other applications such as SQL Anywhere has a OUTPUT statement.

Is there a similar thing in SQL Developer?

SELECT * FROM SalesOrders;

OUTPUT USING 'Driver=Microsoft Excel Driver (*.xls);

DBQ=c:\\test\\sales.xls;

READONLY=0' INTO "newSalesData";

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2015
Added on Aug 4 2015
3 comments
1,554 views