create or replace trigger tianlongsheji after insert on teacher when :new.flg = 1 for each row begin insert into student values (:new.id, :new.flg); end;
CREATE OR REPLACE TRIGGER trg_s_t BEFORE INSERT ON teacher FOR EACH ROW WHEN (NEW.flg=1) BEGIN INSERT INTO student (id,flg) VALUES(:NEW.id,:NEW.flg); END;
insert 触发器中执行 insert 会造成递归的。
create or replace trigger tri_instu before insert on student for each row when (new.flg=1) begin insert into student values(:new.id ,:new.flg); end;
after insert on teacher
when :new.flg = 1
for each row
begin
insert into student values (:new.id, :new.flg);
end;
CREATE OR REPLACE TRIGGER trg_s_t
BEFORE INSERT ON teacher
FOR EACH ROW
WHEN (NEW.flg=1)
BEGIN
INSERT INTO student (id,flg) VALUES(:NEW.id,:NEW.flg);
END;
when (new.flg=1)
begin
insert into student values(:new.id ,:new.flg);
end;