ORALCE JOB

存储过程sql： create or replace procedure job_proc is begin --免费票状态修改 需修改ID update O_2413 set attr_24131004="作废" where attr_24131004="已售"; --普通票状态修改 需修改ID update O_2405 set attr_24051004="作废" where attr_24051004="已售"; --团体票状态修改 需修改ID update O_2412 set attr_24121004="作废" where attr_24121004="已售"; end; job的sql： declare   job number;   begin   dbms_job.submit(job, "job_proc;", sysdate, "TRUNC(SYSDATE + 1)");   end;