SELECT *
FROM (SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLENAME ) A
WHERE ROWNUM <= :page_index* :rowcount_ofpage)
WHERE RN >= (:page_index-1)*:rowcount_ofpage+1
FROM (SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLENAME ) A
WHERE ROWNUM <= :page_index* :rowcount_ofpage)
WHERE RN >= (:page_index-1)*:rowcount_ofpage+1