Re: ProC/SQL question

On Fri, 14 Jun 1996 15:13:54 -0700, Bill Bathurst <bathurst_at_freerange.com> wrote:

>
>Given a search I would like to break our results into smaller chunks
>to make it more readable.
>
>For example:
>
>Display first 1 - 25 SQL search matches found. Stop execution. Re
>execute returning the #26-50 matches found. Reiterate if necessary.
>
>This will implemented in ProC.
>

what is the question?

If you are asking how to do this, look at array fetching. You can array fetch 25 rows, play around with them in the client, array fetch the next 25.

>
>Bill Bathurst http://freerange.com
>Systems Engineer/Oracle DBA/Netrek Clue Freerange Media
>
>GCM d- s a C++ U*+A++B++++C--H---I+L-0++++S++++U++++V+++X+ P+++ L+ W++ N++
>K---- w+ !0 M V PS PE+ Y PGP t+ 5+ X++ R++ tv- b++ DI+++ !D G e+ h+ r z+
>

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com -- Check out our web site! Brand new, uses Oracle Web Server and Database

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Sat Jun 15 1996 - 00:00:00 CEST