只要有KEY,下面的就可以了,替换A,B的名
CREATE OR REPLACE TRIGGER TRI_A
BEFORE DELETE INSERT UPDATE
ON A FOR EACH ROW
BEGIN
IF UPDATEING THEN
UPDATE B SET fld1= :new.fld1
where fld1 = :old.fld1;
END IF;
END;
CREATE OR REPLACE TRIGGER TRI_A
BEFORE DELETE INSERT UPDATE
ON A FOR EACH ROW
BEGIN
...
IF UPDATEING THEN
UPDATE B SET fld1= :new.fld1
where fld1 = :old.fld1;
END IF;