目测, 你是在用 SQL Server 数据库的语法, 在 Oracle 上面写触发器啊......
CREATE TABLE a ( objcode INT, objstate INT);CREATE TABLE b ( objcode INT, objstate INT);INSERT INTO a VALUES( 1, 100);INSERT INTO b VALUES( 1, 100);CREATE OR REPLACE TRIGGER tr_a_Update BEFORE UPDATE OF objstate ON aFOR EACH ROWBEGIN UPDATE b SET objstate = :NEW.objstate WHERE objcode = :OLD.objcode;END;/触发器已创建SQL> SQL> UPDATE a SET objstate = 200 WHERE objcode = 1;已更新 1 行。SQL> SQL> SELECT * FROM a; OBJCODE OBJSTATE---------- ---------- 1 200SQL> SQL> SELECT * FROM b; OBJCODE OBJSTATE---------- ---------- 1 200
取消
评论