Re: Iterate pagewise through huge result set

From: <fitzjarrell_at_cox.net>
Date: Thu, 13 Sep 2007 09:05:26 -0700
Message-ID: <1189699526.594179.310610@y42g2000hsy.googlegroups.com>

On Sep 13, 3: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

Look at:

http://www.devx.com/getHelpOn/10MinuteSolution/16593/1763/page/4

It's an example package which does a very nice job of paginating output; you might think of modifying it to suit your needs.

David Fitzjarrell Received on Thu Sep 13 2007 - 11:05:26 CDT