Creating different worksheets in a single excel [message #654215] |
Thu, 28 July 2016 06:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c0bf37df4de4bda1f122e3c6942e7d8d?s=64&d=mm&r=g) |
venkat111
Messages: 4 Registered: July 2016 Location: Hyderabad
|
Junior Member |
|
|
Hi,
I have one urgent requirement, please help us:
We are generating one report in ORACLE by using UTL_FILE package that is fine. But we nee to create different workheets in a single excel file.
1. Version: Oracle 11g
2. Generating file in using PL/SQl PROCEDURE
3. This PROCEDURE using in Oracle it self, there is no any JAVA call nothing.
EX:
Our query will give:
1
2
3
4
5
6
we need data in one excel like below:
Sheet1
1
2
3
Sheet2
4
5
6
Please help us and add sample code.
|
|
|
|
|