CREATE OR REPLACE TRIGGER tr_temp
BEFORE INSERT OR UPDATE OF code
ON a
FOR EACH ROW
BEGIN
update b.code = :new.code where ...;
commit;
END tr_temp;
/
BEFORE INSERT OR UPDATE OF code
ON a
FOR EACH ROW
BEGIN
update b.code = :new.code where ...;
commit;
END tr_temp;
/
我的,ORACLE 刚学.
谢谢
AFTER INSERT OR UPDATE OF code
ON a
FOR EACH ROW
BEGIN
update b.code = :new.code
commit;
END tr_temp;
当然,若触发器为自动事务类型的话,可以有commit或rollback语句