做个判断啊。如果当前字段时间等于SYSDATE就不执行Update boiler Set gxrq=to_char(Sysdate,'YYYY-MM-DD HH24:MI:SS') Where
那不行的,我的GXRQ必须精确到秒。所以说不管怎么样,都要更新。
create or replace trigger TR_BOILER_AFTERUPDATE after update on boiler for each row declare -- local variables here Begin select to_char(Sysdate,'YYYY-MM-DD HH24:MI:SS') into :new.gxrq from dual; end TR_BOILER_AFTERUPDATE;
after update on boiler
for each row
declare
-- local variables here
Begin
select to_char(Sysdate,'YYYY-MM-DD HH24:MI:SS') into :new.gxrq from dual;
end TR_BOILER_AFTERUPDATE;