Creating different worksheets in a single excel [message #654215] |
Thu, 28 July 2016 06:18 |
|
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.
|
|
|
|
|