ORCLE触发器表1新增数据，数据按条件增加到表2

Question

表uapbp_project中新增一行数据后，如果pk_proclass=1,则把表中的code和name新增到表bd_defdoc中，pk_defdoclist=1，反之表1的pk_proclass=2，就放到表2，pk_defdoclist=2中

Answer 1

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;