Re: Limiting the no. of rows sent to the PC

You could set up a cursor in a package, and set up methods to retrieve them as required. I've even seen cursors set up with *hints* that all subsequent retrievals to return the "previous 5 rows" by following the index backwards.

Good luck!

Sincerely,

Martin Farber
Independent Oracle Consultant "A Jack of all trades and a slave to one."

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1B-23
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216

In article 00130995_at_dge.ceo.dg.com, Michael_Kelly_at_dge.ceo.dg.com (Michael Kelly) writes:
>If this is a dumb question, I apologise in advance.
>
>In a Client/Server environment using SQL*Net V2 and Oracle 7.1.4 on Unix, can
>I (from a PC based app.) ask the Oracle server to retrieve all the rows
>matching a particular filter and then ONLY pass back the first (say) 20
>records to the PC. Can I then 'ask' for more discrete sets of records/rows as
>and when I might want them?
>Basically, can I have (some) control over the amount of net traffic my
>application might generate?
>
>Regards,
>Michael.
>
>Michael_Kelly_at_dge.ceo.dg.com
Received on Tue Mar 14 1995 - 00:31:09 CET