oracle 分页模版

SELECT * FROM  
(  
SELECT A.*, ROWNUM RN  
FROM (SELECT * FROM TABLE_NAME) A  
WHERE RN<= (pageIndex+1)*pageSize
)  
WHERE RN >= pageIndex*pageSize