触发器存在则插入MERGE INTO例子

--新增触发器，当新增险种时记入接口日志表
create or replace trigger LMRisk_trigger
  before insert or update on LMRisk
  for each row
declare
  ip varchar2(20);
  currdate date;
begin
select SYSDATE into currdate from dual;
MERGE INTO ldinterfacelog a USING ( select :new.riskcode as riskcode from dual) du ON(a.otherno=du.riskcode)
    WHEN NOT MATCHED THEN INSERT
    Values (:new.riskcode,'LMR',:new.riskcode,'','',currdate,'00:00:00') ;
end LMRisk_trigger;

/