Export (large) result in SQL Developer
Posted on 2009-06-30
I have a problem exporting query results to an Excell file.
Database: Oracle 10.2.0.4
SQL Developer 1.5.4 build 5940 with patch 59.59
MS Excell 2007
I do a query like 'select * from table;'
When I get the resultset I do:
This works usually fine, but now I have a large resultset.
'select * from bigtable where datecol = to_date(date);'
The resultset has 37 columns.
For a given day I have 41146 rows. This works, I get an xls file of about 22MB.
For another day I have 47040 rows. This is a problem. I get an empty xls file.
So, my question... is there an option for the number of rows? Or filesize?
Has anyone experienced something like this?
I can't find any info on the subject on any site (yet).