//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;