select at offset

Hi freaks,

I want select some rows of a table and "scroll" through the db like this:

while (select next 5 elements) do write elementblock that means I need a select - statement which gets a number of rows at a given offset of the db (including getting previous 5 elements) select * (10-14) of mytable; to get row 10-14 of the table;

how can I query this in oracle?

thanks for Your help!

bye,
Matthias Leonhardt Received on Tue Apr 16 2002 - 08:49:12 CDT