Oracle 存储过程分页

create or replace package body PKG_REPORTS is
procedure PRO_GetZYJSGZJZQTJ_SYQ
(
rq_in_start in date, --开始日期
rq_in_end in date, --结束日期
pageSize in number,
pageIndex in number,
cur_out out pkg_general.ROW_CURSOR
)
AS
BEGIN
OPEN cur_out FOR
select * from (
select a.*,row_number()over(ORDER BY dayCount desc) rn from (
select DH_DEPNAME,c.name zylx,t.sgjx,comm.name jsdw,co.name sgqy,t.jh,null as zyjs,to_char(t.kgsj,‘yyyy-MM-dd’) kgsj,to_char(t.wjrq,‘yyyy-MM-dd’) wjrq,sum(ceil(t.wjrq - t.BJRQ_START)) dayCount
from YXHB_ZYDDSB t
join SYS_COMMONDICVALUE c on t.LX=c.id
join sys_commondicvalue comm on t.jsf=comm.id
join sys_commondicvalue co on t.sgqy=co.id
where t.wjbs=‘1’ and t.sh=‘3’ and t.rq>=rq_in_start and t.rq<=rq_in_end
group by DH_DEPNAME,c.name,t.sgjx,comm.name,co.name,t.jh,kgsj,wjrq
) a
)tt WHERE rn BETWEEN (pageIndex * pageSize) AND ((pageIndex+1) * pageSize) ;

END PRO_GetZYJSGZJZQTJ_SYQ;

end PKG_REPORTS;