Re: [Q] Iterate pagewise through huge result set

From: R. Schierbeek <byteNospam_at_gmail.com>
Date: Thu, 13 Sep 2007 11:25:05 +0200
Message-ID: <46e9010a$0$72736$dbd4b001@news.wanadoo.nl>

> Peter <digory_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

Do you mean in SQLplus ?
Then :
set pages 60
set pause ON
will do it quite efficiently for you.

Cheers, Roelof Schierbeek Received on Thu Sep 13 2007 - 04:25:05 CDT