declare
V_NUM number;
V_NUM := 0;
----判断触发器 TABLE_NAME 是否存在(区分大小写)
select count(0) into V_NUM from user_triggers where trigger_name = 'tib_bpd_business_process_link';
----如果存在立即删除
if V_NUM > 0 then
execute immediate 'DROP TRIGGER tib_bpd_business_process_link';
end if;
----多次删除时,每次都将v_num设置成为0
V_NUM := 0;
----判断触发器 TABLE_NAME 是否存在(区分大小写)
select count(0) into V_NUM from user_triggers where trigger_name = 'tib_bpd_interface_service';
----如果存在立即删除
if V_NUM > 0 then
execute immediate 'DROP TRIGGER tib_bpd_interface_service';
V_NUM number;
BEGIN
V_NUM := 0;
----判断触发器 TABLE_NAME 是否存在(区分大小写)
select count(0) into V_NUM from user_triggers where trigger_name = 'tib_bpd_business_process_link';
----如果存在立即删除
if V_NUM > 0 then
execute immediate 'DROP TRIGGER tib_bpd_business_process_link';
end if;
----多次删除时,每次都将v_num设置成为0
V_NUM := 0;
----判断触发器 TABLE_NAME 是否存在(区分大小写)
select count(0) into V_NUM from user_triggers where trigger_name = 'tib_bpd_interface_service';
----如果存在立即删除
if V_NUM > 0 then
execute immediate 'DROP TRIGGER tib_bpd_interface_service';
end if;
END;