CREATE OR REPLACE TRIGGER dfa01_tri
BEFORE INSERT or delete or update of col ON dfa01
FOR EACH ROW
BEGIN
IF inserting then
insert into dfa031 (JH,YYBH) values (:new.JH,:new.YYBH);
elsif updating then
UPDATE dfa031 SET
..........
WHERE
..........
ELSE
delete from dfa031
WHERE
......;
END IF;
end;
BEFORE INSERT or delete or update of col ON dfa01
FOR EACH ROW
BEGIN
IF inserting then
insert into dfa031 (JH,YYBH) values (:new.JH,:new.YYBH);
elsif updating then
UPDATE dfa031 SET
..........
WHERE
..........
ELSE
delete from dfa031
WHERE
......;
END IF;
end;
字段名 代码
DFA01 JH
DFA01 SYMC
DFA01 YYBHdfa031:
字段名 代码
DFA031 JH
DFA031 YYBH
DFA031 QDGC
BEFORE INSERT or delete or update of YYBH ON dfa01
FOR EACH ROW
BEGIN
IF inserting then
insert into dfa031 (JH,SYMC,YYBH) values (:new.JH,:new.SYMC,:new.YYBH);
ELSIF updating then
UPDATE dfa031 SET
yybh=:new.yybh
WHERE
JH=:old.JH;
ELSE
delete from dfa031
WHERE
JH=:old.JH;
END IF;
end;