Upload Code
loading-left
loading loading loading
loading-right

Loading

Profile
No self-introduction
codes (1)
ORALCE JOB
no vote
SQL stored procedures: create or replace procedure job_proc is begin --Free tickets to modify modify ID Update O_2413 set 'where attr_24131004=' attr_24131004=' void sold '; --Single: modify modify ID Update O_2405 set 'where attr_24051004=' attr_24051004=' void sold '; Corporate voting--modify modify ID Update O_2412 set 'where attr_24121004=' attr_24121004=' void sold '; end; The SQL job: declare job number; begin dbms_job.submit(job, 'job_proc;', sysdate, 'TRUNC(SYSDATE + 1)'); end;
xiegaoshan
2016-08-23
0
1
No more~