sql触发器

--先赋权限
GRANT UPDATE ON  nc002.TD_KHD_YH TO zjjs_666;
GRANT insert ON  nc002.TD_KHD_YH TO zjjs_666;
GRANT delete ON  nc002.TD_KHD_YH TO zjjs_666;
--创建触发器
create or replace trigger triYhzl
  after insert or update or delete
  on td_banktype 
  for each row
declare
  -- local variables here
begin
  if inserting then
     insert into nc002.TD_KHD_YH(yhzlbh,yhzlmc,zt,bz,lrr,sszx,lrsj) 
     values(:new.banktype_code,:new.banktype_name,:new.status,:new.remark,:new.input_user,:new.center_id,:new.input_date);
  end if;
  if updating then
     update nc002.TD_KHD_YH set yhzlbh=:new.banktype_code,yhzlmc=:new.banktype_name,zt=:new.status,bz=:new.remark,lrr=:new.input_user,sszx=:new.center_id,lrsj=:new.input_date where yhzlbh=:new.banktype_code;
  end if;
  if deleting then
     delete from nc002.TD_KHD_YH where yhzlbh=:old.banktype_code;
  end if;
end triYhzl;