How to export query results in excel using PL/SQL in ORACLE?

I am using TOAD and query results are more than toad allows to export.. Is there any alternative?
LVL 5
CalmSoulAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
Are you using TOAD simply to execute the SELECT statement, or perhaps you're adding some manual manipulation?  There may be other factors in play that restrict you.  I often debug by removing any 3rd party product and using SQL*Plus to locate syntax errors.

BTW, the current version of Oracle's (free) SQL*Developer allows a query to be run with certain hints that easily format the result set.  For example, SELECT /*+ CSV */... will forego the need to manually parse all those field delimiters.  HTML, XML, the list goes on.
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
may be you can export them into excel in subset of batches by using a where clause accordingly to restrict the record count returned. you can use one of the unique id columns or something of that sort to differentiate the batches right.

Thanks
0
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
If you do not want to use toad export functionality at all because of the limitation, then i believe you need to code pl/sql to write into the files in the required formats. you can use utl_file package procedures/functions to write to the OS files.

Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.