How to use "rownum"

[sameera s]

Hi,
I am doing a paging task. In order to do that I want to get data 10 by 10 raws from a table. How can I do this using "rownum" ?
I tried in this way

SELECT FROM (
SELECT UPLOAD_DATE_TIME,TYPE_OF_UPLOAD,PERFORMED_BY,STATU S,CLFILE_COUNT,STCMAS_COUNT,CLSTMAS_COUNT,OPENTRN_ COUNT,START_TIME,FINISH_TIME,rownum rn
FROM ONLINE_ACTION_HISTORY where TYPE_OF_UPLOAD='OPERATIONAL' ORDER BY UPLOAD_DATE_TIME DESC) WHERE rn between 1*10-9 and 1*10;

But row numbers are not in the order as table rows. It has different order. Please help me to solve this problem.
Thanks in advance

[amitpatel66]

Try this:

SELECT * FROM(
SELECT UPLOAD_DATE_TIME,TYPE_OF_UPLOAD,PERFORMED_BY,STATU S,CLFILE_COUNT,STCMAS_COUNT,CLSTMAS_COUNT,OPENTRN_ COUNT,START_TIME,FINISH_TIME,rownum rn FROM (
SELECT UPLOAD_DATE_TIME,TYPE_OF_UPLOAD,PERFORMED_BY,STATU S,CLFILE_COUNT,STCMAS_COUNT,CLSTMAS_COUNT,OPENTRN_ COUNT,START_TIME,FINISH_TIME 
FROM ONLINE_ACTION_HISTORY where TYPE_OF_UPLOAD='OPERATIONAL' ORDER BY UPLOAD_DATE_TIME DESC))
WHERE rn between 1*10-9 and 1*10
/
 

[sameera s]

I tried it and it works
Thanx Amith... :)