Limiting the no. of rows sent to the PC

From: Michael Kelly <Michael_Kelly_at_dge.ceo.dg.com>
Date: Thu, 9 Mar 1995 19:02:07
Message-ID: <Michael_Kelly.27.00130995_at_dge.ceo.dg.com>


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 Thu Mar 09 1995 - 19:02:07 CET

Original text of this message