oracle 生产job语句

每小时00分00秒执行；

declare
insert_job number;
begin
sys.dbms_job.submit(job => insert_job,
what => 'InsertCollectData;',
next_date => TRUNC(sysdate,'hh24') +1/24,
interval => 'sysdate+1/24');
commit;

end;

简单记录，防止忘记；