/**

定时更新库存(每天凌晨1点执行)

**/

VAR job1 number;

begin

dbms_job.submit(:job1,'UPDATE_STOCK;',TRUNC(SYSDATE+1)+1/24,'TRUNC(SYSDATE+1)+1/24');

COMMIT;

end;