Is it possible to limit the number of rows that are returned (say 300) from a select statement using SQL passthrough to an Oracle database.

IF so, is it possible to then retrieve the next 300 rows.

Currently, I am doing a count of the number of rows that would be returned from the query. If the number is greater than 300 I display a message box giving the user the option of retrieveing the data or allowing them to narrow the scope of their query.

Any help would be greatly appreciated.

Greg