create or replace procedure name_pro(p1 in number,p2 in varchar2)
as
cursor t_sor(v1 number,v2 varchar2) is
select * from 表 where col1_name=v1 and col2_name=v2;
begin
for v_sor in t_sor(p1,p2) loop
处理过程;
end loop;
end;
/
as
cursor t_sor(v1 number,v2 varchar2) is
select * from 表 where col1_name=v1 and col2_name=v2;
begin
for v_sor in t_sor(p1,p2) loop
处理过程;
end loop;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货