In MySQL, you can use “Limit n,m”, like this:
select * from sometable order by name limit 20,10
How to do in Oracle?
select * from ( select a.*, ROWNUM rnum from ( <your_query_goes_here, with order by> ) a where ROWNUM <= :MAX_ROW_TO_FETCH ) where rnum >= :MIN_ROW_TO_FETCH
select * from ( select a.*, ROWNUM rnum from ( select * from sometable order by name ) a where ROWNUM <= 30) where rnum >= 20
You can visit this page for more information: http://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering
Some Oracle tools you can try: https://www.withdata.com/oracle/