ORALCE JOB
2016-08-23
0 0 0
no vote
Other
Earn points
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;
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;
others
ORALCEJOB
Related Source Codes
Dream Adventure game BOT
0
0
no vote
IFC file parsing
1
0
4.0
Cloud computing KVM virtual machine production pro
0
0
no vote
OTP reader
1
0
no vote
Particle swarm optimization algorithm
2
0
no vote
No comment