Reading 100 rows at a time...

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?

Thank you!
Sergey

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 09 2000 - 10:01:32 CDT