there is no limit function in oracle sql. what you can do is a query using rownum < some value with a subquery to get all the data
ex
select rownum as rank, field1, field2...fieldn
from (select field1, field2...fieldn from table_name
order by field1, field2... fieldn)
where rownum <50;
this would take the first 50 rows from the table
what you coul do, is to place a counter in the page and then change 50 to a variable to be used to figure out which new records need to be retrieved.
the other option is to use session array to store the variables as you page thru them, the downside is that it uses a lot of memory on the server and may slow things down if a number of concurrent users are doing the same query
