oracle定时执行存储过程

//create table

?

create table getSysDate(test date);

?

?

//create procedure

create or replace procedure insertSysDate as 
begin 
insert into getSysDate values (sysdate);
end ;

?//create job

declare
job1 number;
begin
dbms_job.submit(job1,'insertSysdate;',sysdate,'sysdate+1/1440');//每份钟插入系统时间
commit;
end;

?

?

详细了解：http://www.cnblogs.com/shurrik/archive/2010/02/25/1673234.html

我的异常网推荐解决方案：oracle存储过程,http://www.aiyiweb.com/oracle-develop/177537.html