Re: Iterate pagewise through huge result set

On Sep 13, 1:53 am, digory <dig..._at_gmx.net> wrote:
> Hi
>
> I have a query that returns a huge result set and would like to
> display the results page by page to the user, similar to the way how
> Google displays its results. To do this, I have to first find an
> approximation of the number of rows returned, then fetch results page
> by page. How do I do this in Oracle SQL? It has to be done as
> efficiently as possible.
>
> Thanks for your reply in advance,
> Peter

Also search the term pagination on http://asktom.oracle.com .

jg

--
@home.com is bogus.
I have no mouth and I must scream.
http://www.itnews.com.au/News/60752,storm-worm-botnet-more-powerful-than-top-supercomputers.aspx