求pl/sql分页存储过程,能返回多行记录集,sqlserver是这样实现的,pl/sql怎样实现,求解:
- SQL code
SQL codeselect * from (select *,row_number() over(ORDER BY trandate) as num from #t) aa where num between (@CurrPage-1)*@PageSize+1 and @CurrPage*@PageSize
------解决方案--------------------
传进sql和参数，传出一个sys_refcursor
关键地方就一句 : open c /*sys_refcursor的名字*/ for sql;