create table student (id varchar2(16), flg number(1));create table teacher (id varchar2(16), flg number(1));create or replace trigger tea2stuafter insert on teacher for each rowbegin if :new.flg = 1
then
insert into student(id,flg) values(:new.id,:new.flg);
end if;end;
create or replace trigger triger_studentafter insert on teacher
for each RowDeclarev_Flg Varchar2(10); --这个看你实际的类型BeginSelect :New.Flg Into v_Flg From Dual;