准备SQL语句

UPDATE ceshi SET error_count = 0 WHERE a = 1 AND b = 2;

创建存储过程

CREATE OR REPLACE PROCEDURE UPDATE_COUNT IS  
BEGIN  
   UPDATE ceshi SET error_count = 0 WHERE a = 1 AND b = 2;  
   COMMIT;  
END;

创建定时器

DECLARE  
   UPDATE_COUNT_time number;  
BEGIN  
   SYS.DBMS_JOB.SUBMIT(  
      job => UPDATE_COUNT_time,  
      what => 'UPDATE_COUNT;',  
      next_date => SYSDATE,  
      interval => 'sysdate+300/86400');  
END;