Here is my requrement,I have a table(username,requestdate,createdate).I want to make a report where I give user his department and some other details from different places and reauest dates and create dates.Now I am running a query for each user once to get his dates,I wanted to use a scrollable resultset,where I query database only once and use this result set each time instead of running a query every time.But my users are not ordered,initially I want dates of user 'arun' , then I need dates of user 'manick' etc.For this purpose how can I scroll the result.

Thanks,
Pandu