Question

Oracle下，如何在两个表间创建触发器？

创建触发器实现当学生表学号改变的时候成绩表中中的学号相应修改，这个涉及到两个表，而且成绩表中一个学号对应很多学科的成绩。我试着写了下：create or replace trigger trg_upd
after update of s_no on student
referencing old as old_value
new as new_value
for each row
begin
update score set score.no=new_value where score.no=old_value;
end;
/
结果提示：Warning: Trigger created with compilation errors. 找了很多资料，没有讲到如何在两个表间建立触发器。希望高手指点！

Answer 1

你的语法有些问题。
create or replace trigger trg_upd
after update on student
for each row
when (NEW.s_no <> OLD.s_no )
begin
update score set score.s_no =:NEW.s_no where score.s_no =:OLD.s_no ;
end trg_upd;
/

Answer 2

create or replace trigger trg_upd
after update on s_no on student

new as new_value
for each row
begin
update score set score.no=new_value where score.no=old_value;

update score set score.no = :new.列名 where scroe.no = :old.列名
end;