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;