| Displaying N number of rows from a large result set [message #571753] |
Thu, 29 November 2012 23:18  |
|
|
I have a query that returns 11 Million rows but not all of them can be displayed in SQLDeveloper or DBVisualizer because of limited memory or other type of issues. I need to copy the entire result set to excel for further calculations.
Is there any way that i can select N number of rows out of my actual result set.
For example:
a) A result set contains 10 Million rows in total.
b) I want to display first 5 Million rows by executing a query
c) Then I want to display the remaining 5 Million rows by executing the query again with any parameter changes.
So all I want is to extract the rows of my actual result set in two or more executions, depending on the number of rows.
Thanks in advance for your help.
|
|
|
|
|
|
| Re: Displaying N number of rows from a large result set [message #571761 is a reply to message #571753] |
Fri, 30 November 2012 02:36  |
 |
dariyoosh
Messages: 229
Registered: March 2009
Location: Iran / France
|
Senior Member |
|
|
syednoman84 wrote on Fri, 30 November 2012 06:18... A result set contains 10 Million rows in total... I need to copy the entire result set to excel for further calculations ...
As far as I know since Excel 2007, you're limited to almost 1,000,000 rows. So even if you split the result set into several separated parts, as I understand (according to what you explained in the OP) the final purpose is to assemble the whole result set in a single Excel file. With the max limit of 1,000,000 rows I think you will be in trouble unless you use Excel 2013 with PowerPivot built-in.
Regards,
Dariyoosh
[Updated on: Fri, 30 November 2012 02:43] Report message to a moderator |
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
