Re: Reading 100 rows at a time...

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Tue, 10 Oct 2000 10:27:37 -0400
Message-ID: <39E32759.12E5A7B7@Unforgetable.com>

sergey_s_at_my-deja.com wrote:

> >
>
> Well, I am actually using PL/SQL. I have a big table and I would like
> to select the first 100 rows out of it and then the next 100, and then
> the next 100, and so on. I am hoping to reduce the processing time by
> reading, caching and operating on a chunk of 100 rows at a time.

If you are working with Oracle 8i then you can use the BULK COLLECT clause in your cursor. However, setting this up is not trivial. If you are serious about his then get the book "Oracle PL/SQL Programming-Guile to Oracle8i Features" by Steven Feurerstein (O'Reilly). I took a look at it and it is complex enough that I don't think that the process can be readily explained in just an email because it involves user-defined objects as well as some different SELECT statement syntax.

You might also take a look at the on-line documentation and search for the word "bulk". Received on Tue Oct 10 2000 - 09:27:37 CDT