Home » SQL & PL/SQL » Client Tools » Several Short Fetch To Retrieve Records (Plsql,8,Linux)
Several Short Fetch To Retrieve Records [message #487547] Tue, 28 December 2010 10:06 Go to next message
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 Go to previous message
ThomasG
Messages: 3208
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?
Previous Topic: PL SQL Developer SLOW LOGIN
Next Topic: Error: "ORA-00900: invalid SQL statement" after executing procedure
Goto Forum:
  


Current Time: Mon Oct 15 15:11:06 CDT 2018