[Q] Iterate pagewise through huge result set

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 Received on Thu Sep 13 2007 - 03:53:52 CDT