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 LazyDBA home page