Oracle定时任务:
----功能说明:每秒执行一次
declare job_use_daily number;
begin
dbms_job.submit(job_use_daily,'declare retCode number; retMsg varchar2(200); begin pro_test (retCode,retMsg); end;',sysdate,'sysdate+1/86400');
commit;
end;
转载于:https://www.cnblogs.com/LoveShare/p/11512341.html