通过触发器通过一个表的添加删除操作另一个表里的信息添加删除

 

create or replace trigger SMS_WORKFLOW
  AFTER  INSERT  OR DELETE ON t_station_info
  for each row
declare
  -- local variables here
begin
  IF INSERTING THEN
     INSERT INTO t_station_sim(stationcode) VALUES(:NEW.stationcode);
  ELSIF DELETING THEN
    DELETE FROM t_station_sim WHERE stationcode=:OLD.stationcode;
  END IF;
end SMS_WORKFLOW;