create or replace procedure search (p_min integer,p_max Integer,p_rowset out sys_refcursor)
is
begin
open p_rowset for
select * from (select rownum r,table_name.* from table_name where rownum <= p_max) t
where t.r >= p_min;
end search;
利用存储过程实现oracle的分页查询
最新推荐文章于 2021-04-08 05:41:35 发布