This may be of help ...

select * from
(select r, empno, ename from (select rownum r, ename, empno
from emp order by empno) where r >
5)
where r < 10
/

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019


-----Original Message-----
From: Simon Hickling [mailto:Simon.[Email Address Removed] Thursday, February 28, 2002 6:01 PM
To: LazyDBA.com Discussion
Subject: Selecting data from the middle of a result set


Hi all,

Does anyone know of a way to extract the nth to n+20th records of a select
statement ?

I want to do this to use it for displaying pages of data and moving to a
particular page. Using a cursor would seem the obvious thing to do, but
this could be a little slow for data in the last page of a large result set.

Cheers

Simon

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page