---定时器 declare job number; begin sys.dbms_job.submit(job, what => 'p_test;', next_date => to_date('22-10-2008 10:06:41', 'dd-mm-yyyy hh24:mi:ss'), interval => 'sysdate+1/1440'); --每天1440分钟,即一分钟运行test过程 一次 ---每天午夜执行一次 --- interval => 'TRUNC(sysdate+1)'); commit; end; ---存储过程 create or replace procedure p_test as begin insert into student (id, name) values (sysdate, sysdate); commit; end;