Several Short Fetch To Retrieve Records [message #487547] |
Tue, 28 December 2010 10:06 |
|
smc2
Messages: 1 Registered: December 2010
|
Junior Member |
|
|
Hi ..
I have a big database, I want to retrieve its records in several tries;
first I use "select * from dbname where rownum <1000"
but for 2'th try how can I get next 1000 records but not previous records?
Thanks in Advance.
|
|
|
Re: Several Short Fetch To Retrieve Records [message #487548 is a reply to message #487547] |
Tue, 28 December 2010 10:14 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
You can't with multiple select. Once you finish one select and start the next, there is no guarantee that the first 1000 rows in the first select will be the same in the second select, because someone might have inserted some new rows that are now part of the first 1000, or deleted the first 500 rows you got in the first select.
What is the actual problem you are trying to solve?
|
|
|