create or replace trigger insert_B after insert FOR EACH ROW
on A
begin
IF :NEW.type = 2 and :NEW.applytype = 11 then
insert into B(id,name,type,applytype,result) values(:NEW.id.:NEW.name,:NEW.type,:NEW.applytype,'Y');
END IF;
END;
/
内容全部来源于网络收集，如有侵权，请联系网站删除！