Re: Reading 100 rows at a time...

sergey_s_at_my-deja.com wrote:

> What's the best way to read through a result set 100 rows at a time?
>
> Say, I just want to examine the data in 100 row increments. Using
> ROWNUM, I can do WHERE ROWNUM <= 100, WHERE ROWNUM <= 200, etc. But
> this means starting from the beginning every time. So, pretty soon this
> can get really slow. I found that WHERE ROWNUM BETWEEN 101 AND 200
> comes back with 'no rows selected'. Is there another way of doing this?
>

It all depends on what you are using for the client application. In Pro-C or OCI the process is extremely easy, In VB it is pretty difficult. What are you using? Received on Mon Oct 09 2000 - 14:23:30 CDT