oracle¼¶Áª¸üÐÂ

дÁ˸ö´¥·¢Æ÷£¬ÓеãÎÊÌ⣬ûÃ÷°×

create or replace trigger person_trg after update on t_person for each row
begin
update t_debt set fname=:new.fname where fname=:old.fname;
end;

¾¯¸æ£º´¥·¢Æ÷±»´´½¨ ÓбàÒë´íÎó

SQL> show error
´íÎó£ºTRIGGER BAHAMUT.PERSON_TRG:

LINE/COL ERROR
-------- ----------------------------------------
2/42    PL/SQL: ORA-00904: "FNAME": ÎÞЧµÄ±êʶ·û
2/1      PL/SQL: SQL Statement ignored

SQL> select * from t_person
  2  /

FNAME                      FAGE FREMARK
-------------------- ----------- --------------------
»¨½£Ô                        25 ±£·Ñ²¿
¶¹Ñ¿²Ë                        22 Òµ¹Ü²¿
Á÷ÀËËĺ£                      22 ÍÅÏÕ²¿


ÓÐfnameÕâ¸ö×ֶΣ¬Ã»Ã÷°×

---

Óõݹ顣
sql¡£

---

ÒýÓÃ

create or replace trigger person_trg after update on t_person for each row
begin
update t_debt set fname=:new.fname where fname=:old.fname;
end;
t_debt ´æÔÚfnameÓÐɶÓã¬ÄãµÄnew.fname£¬old.fname;
ÕâÀïÕë¶ÔµÄÊÇt_person ×öµÄ£¬¼ì²éÏÂt_person ²»´æÔÚfnameÕâ