表uapbp_project中新增一行数据后,如果pk_proclass=1,则把表中的code和name新增到表bd_defdoc中,pk_defdoclist=1,反之表1的pk_proclass=2,就放到表2,pk_defdoclist=2中
create or replace trigger uapbp_project_trigger
after insert
on uapbp_project
for each row
begin
case
when :new.pk_proclass = 1 then
insert into bd_defdoc(code, name) values (:new.code,:new.name);
when :new.pk_proclass = 2 then
insert into 表2(code, name) values (:new.code,:new.name);
end case;
end;