Hi Tim and All

Thanks for your immediate and comprehensive reply. Howeverit will be very nice if you can explain me using the following case. Take our regular scott tiger schema .. there are 14 records

select empno, ename from emp;

o/p :

EMPNO ENAME
----- ------
7369 SMITH
7499 ALLEN
7521 WARD
7566 JONES
7654 MARTIN
7698 BLAKE
7782 CLARK
7788 SCOTT
7839 KING
7844 TURNER
7876 ADAMS
7900 pravin
7902 FORD
7934 MILLER

14 rows selected.

I run it using your method as I cannot allow more than 10 rows in one page.

SELECT empno, ename
FROM emp
WHERE empno < 7777
AND rownum < 10
ORDER BY empno;

EMPNO ENAME
----- ------
125 ajay
7369 SMITH
7499 ALLEN
7521 WARD
7566 JONES
7654 MARTIN
7698 BLAKE

7 rows selected.

And now how do I go next 7 records. I don't know about anything in XML or DOM. I am using Stored Procedures and functions to retrive the data (This function is called from Java Code).DO I have to pass the value at 7777 from Procedure. Or that has to be kept incrementing by a certain count.

I guess that will help you to answer my query ?

Thanks in Advance