query return result in packates

Hi,

i'm new in database and i was working on fetching large volume of data from my database and want to do something. now i want know that is there any method that when i execute query in loop and get specific no. of rows in resultset and after process these rows get further rows.

e.g i put a query on a table contains 1000 rows. i want that first time execution it return me 100 rows after processing these 100 again query return next 100 rows in result set. i don't want the whole data in resultset at one time.

i need help and plz suggest if there is anyother method for this.

Regards

mohit

[633 byte] By [mohitmehtaa] at [2007-11-26 14:25:43]