oracle触发器学习
当修改一个表的一个字段时,触发器自动修改另一表的相应字段
例如:
--创建表stu_info1
create table stu_info1(id number,name varchar2(32),college varchar2(32),primary key(id));
--创建表stu_info2
create table stu_info2(id number,college varchar2(32),primary key(id),foreign key(id) references stu_info1(id));
--创建一个名为stu_info的触发器,当修改表stu_info2时,就根据主键更新表stu_info1相应列
CREATE OR REPLACE TRIGGER stu_info
AFTER UPDATE
ON stu_info2
FOR EACH ROW
BEGIN
update stu_info1 set COLLEGE=:new.college where stu_info1.id=:old.id;
END stu_info;
CREATE OR REPLACE TRIGGER 触发器名
AFTER UPDATE
ON 表2
FOR EACH ROW
BEGIN
update 表1 set COLLEGE=:new.college where 表1.id=:old.id;
END 触发器名;