oracle 触发器
数据库的表有变动的情况下oracle会自动调用这个触发器:
CREATE OR REPLACE TRIGGER TR_BS_BOTTLEINFO
BEFORE INSERT OR UPDATE ON BS_BOTTLEINFO
FOR EACH ROW
DECLARE
BEGIN
:NEW.UPDATEDATE:=SYSTIMESTAMP;
END;
BEFORE INSERT OR UPDATE ON BS_BOTTLEINFO
FOR EACH ROW
DECLARE
BEGIN
:NEW.UPDATEDATE:=SYSTIMESTAMP;
END;