Skip to Main Content
Forums

SQL Developer

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 a resultset from SQL developer to excel

913877Feb 22 2012 — edited Feb 18 2013
Hi,

The result set of one of my query contains around 15 million rows. Am trying to copy the resultset to an excel by right clicking the resultset and then using -> export data ->xls.
But this operation is very slow as only 100,000 rows are getting loaded in last 10 minutes.

Is there a way to create a pivot table in spreadsheet use my the result set in SQL developer as a source?

Regards
-Learnsequel

Edited by: 910874 on Feb 22, 2012 2:15 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2013
Added on Feb 22 2012
#sql-developer
8 comments
17,871 views