How to display page wise records in Oracle Database?

Question

I have one table with name emp with columns id, name, address. I want SELECT records first 10 and then next 10 and so on depends on the variable. Please let me know how can I achieve this?

Answer 1

You can use below SELECT statement:

SELECT * FROM EMP where rownum between 1 and 10;

You can use 1 and 10 as two variables and replace it dynamically.