Warroom/warroom-system/Library/Mirle.Component.Database.Model.WES/Current/Trigger/CUR_ALARM_DATA.sql

--------------------------------------------------------
--  DDL for Trigger CUR_ALARM_DATA
--------------------------------------------------------

CREATE OR REPLACE EDITIONABLE TRIGGER "MIRLE"."CUR_ALARM_DATA" 
AFTER UPDATE OF END_TIME ON CUR_ALARM_DATA 
BEGIN
    insert into HIS_ALARM_DATA 
    select CUR_ALARM_DATA.*, systimestamp as "HISTORY_TIME" from CUR_ALARM_DATA where end_time is not null;
    delete CUR_ALARM_DATA where end_time is not null;
END;
/
ALTER TRIGGER "MIRLE"."CUR_ALARM_DATA" ENABLE;