表1: create table student ( sno varchar2(6) not null, sname varchar2(6) not null, ssex varchar2(2) not null, sage varchar2(2) not null, sclass varchar2(20) not null, constraint a1 primary key(sno), constraint a2 check(ssex in('男','女')), constraint a3 check(sage between 18 and 28) ); 表2: create table student2 ( sno varchar2(6) not null, sname varchar2(6) not null, ssex varchar2(2) not null, sage varchar2(2) not null, sclass varchar2(20) not null, constraint a1 primary key(sno), constraint a2 check(ssex in('男','女')), constraint a3 check(sage between 18 and 28) ); 实现两张表同步的触发器: create or replace trigger test after insert or update or delete on student for each row begin if inserting then insert into student2 values(:NEW.sno,:NEW.sname,:NEW.ssex,:NEW.sage,:NEW.sclass); elsif updating then update student2 set sname=:NEW.sname, ssex=:NEW.ssex, sage=:NEW.sage, sclass=:NEW.sclass where sno=:OLD.sno; elsif deleting then delete from student2 where sno=:old.sno; end if; end;