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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

post data from Toad to Excel

User_JOHIRFeb 23 2012 — edited Feb 24 2012

I have written a query in Toad. It retrieves very huge data around 5000000 records. Now I want to export this data from Toad to Excel with faster rate. I tried to export using Save as and then gave the filename as "file.xls and enabled add include column headers. It got executed for 200000 records. But after that got a error message exceeds the limit.

can any one please suggest me how to export the while data with faster rate from Toad to excel.

Thanks,
Vas.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2012

Added on Feb 23 2012

10 comments

1,781 views