If you want to fetch for each page then you need to use ORDER BY and ROWNUM. Let's say I join 3 tables emp, dept, loc and I need n rows at a time.
The query would be
You need to bind the values for ROWNUM predicate.
- ROWNUM does not ensure that records are fetched in any particular record. If you fire a query like SELECT * FROM emp WHERE rownum < 10 Oracle does not guarantee you will get same set of 10 row very time. The ORDER BY clause will help to overcome this unpredictable behavior.
No one can make you feel inferior without your consent - Eleanor Roosevelt. tiny ad: