create or replace trigger TRAFFIC_ROAD_STATUS_TR_AU
  after update on traffic_road_status 
  for each row
declare
  -- local variables here
begin
        
  update TRAFFIC_ROAD_STATUS_HISTORY set DELETE_DATE=sysdate where
           insert_date = (select max(insert_date) from traffic_road_status_history where ROAD_ID = :new.ROAD_ID) and
           ROAD_ID = :new.ROAD_ID and
           DELETE_DATE is null;
  insert into TRAFFIC_ROAD_STATUS_HISTORY(Road_Id, Status_Id, Source_Id, Speed, Timestamp, Memo, Insert_Date) values
         (:new.ROAD_ID, :new.STATUS_ID, :new.SOURCE_ID, :new.SPEED, :new.TIMESTAMP, :new.MEMO, sysdate);
          
end TRAFFIC_ROAD_STATUS_TR;