触发器

CREATE OR REPLACE TRIGGER update_rolejurisdiction
AFTER UPDATE ON zxauthen.zx0103
FOR EACH ROW
BEGIN
update t_xzzf_rolejurisdiction t set t.rolecode = :NEW.code,t.rolename = :NEW.rolename where t.id = :OLD.id;
END;

CREATE OR REPLACE TRIGGER update_rolejurisdiction2
AFTER UPDATE ON zxauthen.zx0009
FOR EACH ROW
BEGIN
update t_xzzf_rolejurisdiction t set t.jurisdictioncode = :NEW.code,t.jurisdictionname = :NEW.name where t.jurisdictionid = :OLD.id;
END;

select * from all_triggers where table_name='ZX0103'
select * from all_triggers where table_name='ZX0009'