Re: Limiting Large Result Sets

smartnhandsome_at_gmail.com wrote:
> Hi,
>
> I would be glad if someone could provide solution for this problem.
>
> working ENV:
> Jdeveloper 10.1.3 - Development
> Oracle 9i - Database
> Windows XP - OS
>
> I want to retrieve about 30 rows at a time . The table contains over 2
> million rows. I would like to begin at the first row and drag 30 rows
> over the network. Then get the next 30 and repeat the process untill
> all rows are displayed.

Generally you don't need to do anything special to accomplish this. You can just "fetch" a row at a time, and behind the scenes the OCI library (or whatever it is that ends up doing the low-level calls) will pre-fetch 30 or 100 or whatever, and transparently cache them locally for you.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB