Oracle触发器

 

功能：触发2个时间间隔之间的某条数据。

CREATE OR REPLACE TRIGGER biud_AC_HISTORYRECORD
BEFORE insert
ON AC_HISTORYRECORD
FOR EACH ROW
DECLARE
v_TEMP   VARCHAR2(100);
BEGIN
     v_TEMP:=:NEW.pass_date ||' '|| :NEW.pass_time;   --||接连符号
      UPDATE XG_LOG
      set TIME=v_TEMP,FLAG='1'
     -- where pp_id='0334' and
     --       spot_id='100064' and
     --       ytimes >='2004-09-01 23:10' and
      --      ytimee <='2004-09-03 00:10';
      where pp_id = :NEW.user_id  and
            spot_id = :NEW.door_id  and
            --to_char(ytimes) >= v_TEMP  and
           -- ytimee <= v_TEMP
            v_TEMP  between  ytimes and ytimee ;
            
end;