CREATE OR REPLACE TRIGGER dfa01_tri
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
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