这是一个例子。在INSERTING/UPDATING/DELETING中加入判定条件,就可以实现了--触发表
CREATE TABLE TTRIG (ID CHAR(5),VALUE NUMBER(10,2));
--触发器操纵表
CREATE TABLE TTR (ID CHAR(5),VALUE NUMBER(10,2));CREATE OR REPLACE TRIGGER tr_bf_TTRIG
BEFORE INSERT OR UPDATE OR DELETE
ON TTRIG
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO ttr VALUES(:new.ID,:new.VALUE);
ELSIF UPDATING THEN
UPDATE ttrig SET ID = :new.ID
WHERE ID = :old.ID;
ELSE
DELETE FROM ttr
WHERE ID = :old.ID;
END IF;
END tr_bf_TTRIG;
/
CREATE TABLE TTRIG (ID CHAR(5),VALUE NUMBER(10,2));
--触发器操纵表
CREATE TABLE TTR (ID CHAR(5),VALUE NUMBER(10,2));CREATE OR REPLACE TRIGGER tr_bf_TTRIG
BEFORE INSERT OR UPDATE OR DELETE
ON TTRIG
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO ttr VALUES(:new.ID,:new.VALUE);
ELSIF UPDATING THEN
UPDATE ttrig SET ID = :new.ID
WHERE ID = :old.ID;
ELSE
DELETE FROM ttr
WHERE ID = :old.ID;
END IF;
END tr_bf_TTRIG;
/
WHERE ID = :old.ID;
应该是Update ttr 吧.