Oracle Database Limiting the rows returned by a query (Pagination) Pagination in SQL
Example
SELECT val
FROM (SELECT val, rownum AS rnum
FROM (SELECT val
FROM rownum_order_test
ORDER BY val)
WHERE rownum <= :upper_limit)
WHERE rnum >= :lower_limit ;
this way we can paginate the table data , just like web serch page
