ORACLE数据库分页语句

下面两种用可以用rownum的变通方式实现分页：
select * from
(select rownum row_num,month,sell from
(select month,sell from sale group by month,sell)
) where row_num between 5 and 9;【网友评论】

select dmp.row_num,dmp.REQUIREMENT_ID from
(select rownum as row_num, REQUIREMENT_ID from
(select REQUIREMENT_ID from requirement order by REQUIREMENT_ID desc)
) dmp
where row_num between 10 and 20;【网友评论】

create or replace procedure GetDataByPage
(
p_sql in varchar,
p_pageSize in number,
p_pageIndex in number,
refcur out pkg_cursor.refcur, --要定义
rowsCount out number)
as

newSql varchar(2100);
beginRow number;
endRow number;
tempRowsCount number;
begin
beginRow:=p_pageSize*p_pageIndex+1;
endRow := beginRow+p_pageSize-1;
execute immediate 'select count(*) from ('||p_sql||')' into tempRowsCount;
rowsCount := tempRowsCount;
newSql :=