ORACLE 程序员开发笔记

1. 创建JOB
begin
  sys.dbms_job.submit(job => :job,
                      what => 'USER_ABC.PRC_SYNINFO;',
                      next_date => to_date('12-02-2009 16:41:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(SYSDATE,''MI'') + 40/ (24*60)');
  commit;
end;