3,491
社区成员
发帖
与我相关
我的任务
分享
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;
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;