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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,544 views