scrolling through tables

While building an application i am experiencing the following problem:

I want to select an 'window' from a selection from a table, in order to scroll through a table with increments of say 10 records at a time. A very simplistic view to this problem is:

select * from table where rownum >10 and rownum < 20;

this however won't work according to the oracle docs.

Anyone got a suggestion?

herbert_at_veronica.nl Received on Wed May 13 1998 - 05:19:58 CDT