Skip to Main Content

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!

Creating a multi-Tabbed .csv file using UTL_FILE

Slippery JimDec 21 2016 — edited Dec 23 2016

Hi,

We're using Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.

I want to send output to a .csv file using UTL_FILE.

The client wants the .csv file to have multiple tabs with each tab containing output from a different sql statement.

Ho can I do this? I have the code written to output the data to a plain .csv file but how does one send additional batches of data to different tabs in the same .csv file?

Thanks,

Degriz

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2017
Added on Dec 21 2016
20 comments
4,228 views