SQL & PL/SQL

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!

sql outputs to excel sheets

Ora_83Jan 10 2010 — edited Aug 21 2013

Hi;

From sqlplus, I can write the output of the sql query to csv file.

What I want to do is,
Suppose my excel file which consist of two seperate sheets.
When I execute query1 it should write the output to sheet1.
When I execute query2 it should write the output to sheet2.

How can I do that? Any suggestion?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2013

Added on Jan 10 2010

#excel, #plsql, #xml

21 comments

14,937 views