oracle 编写触发器，实现数据插入和更新时自动记录当前时间

UPDATETIME 默认时间为当前系统时间spa

触发器脚本以下：blog

create or replace trigger trigger_testclass

before insert or update on RANDOM_ORDERS for each rowtest

begindate

   select sysdate into :new.UPDATETIME from dual;select

end;im

其中，trigger_test为触发器名称，RANDOM_ORDERS为表名，UPDATETIME为表中的字段名称datetime

===================================================================================脚本

根据不一样的操做执行不一样的操做脚本以下(RANDOM_ORDERS_copy 为RANDOM_ORDERS的复制表)：margin

create or replace trigger trigger_tz before insert or update or delete

on RANDOM_ORDERS for each row

begin

if inserting then

    select sysdate into :new.updatetime from dual;

elsif updating then

    select sysdate into :new.updatetime from dual;

elsif deleting then

   -- select into purchases_copy from old;

    insert into RANDOM_ORDERS_copy(CUSTOMERID,PRODUCTID,ORDERDATE，UPDATETIME) values (:old.CUSTOMERID,:old.PRODUCTID,:old.ORDERDATE,:old.UPDATETIME);

end if;

end;