create or replace procedure pro_test(p_owner) as
v_str varchar2(200):='';
v_triggername varchar2(100):='';
cursor c is select a.trigger_name from all_triggers a where a.owner=p_owner;
begin
open c;
loop
fetch c into v_triggername;
exit when c%notfound;
v_str:='alter trigger '||p_owner||'.'||v_triggername||' disable' ;
execute immediate v_str;
end loop;
close c;
exception
when others then
null;
end;
--未经测试,
v_str varchar2(200):='';
v_triggername varchar2(100):='';
cursor c is select a.trigger_name from all_triggers a where a.owner=p_owner;
begin
open c;
loop
fetch c into v_triggername;
exit when c%notfound;
v_str:='alter trigger '||p_owner||'.'||v_triggername||' disable' ;
execute immediate v_str;
end loop;
close c;
exception
when others then
null;
end;
--未经测试,
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货