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;
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);
(:new.ROAD_ID, :new.STATUS_ID, :new.SOURCE_ID, :new.SPEED, :new.TIMESTAMP, :new.MEMO, sysdate);
end TRAFFIC_ROAD_STATUS_TR;
转载于:https://blog.51cto.com/lifanfly/201843