Getting rows in a set.

Hi all,

I am working on a project where I am sending JDBC queries to Oracle, my problem is the resultset fetches all the rows even when they are too many,
giving me out of memory errors..
  Is there any way in Oracle to implement functionality like ,get next 30 rows, such
that only subset of rows are fetched.

Thanks
Dhiraj.
dsoni_at_uswest.com Received on Thu Jul 01 1999 - 18:28:35 CDT