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!

Exporting to excel in multiple worksheets

user7351276Feb 6 2011 — edited Sep 23 2011
Help please

I have to export to excel from pl/sql.

My results are greater than 1 million records.
so is it possible to export to one excel file till max rows (65000) is reached and then create multiple worsheets on the same excel to insert the remaining data's.



Please requesting your help on this....


thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2011
Added on Feb 6 2011
15 comments
4,008 views