Home » Source Code » ORALCE JOB

ORALCE JOB

xiegaoshan
2013-12-30 00:28:11
The author
View(s):
Download(s): 0
Point (s): 1 
Category Category:
DataBaseDataBase OthersOthers

Description

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;

Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
TscLibDllTest.sln904.00 B18-01-08 14:04
TscLibDllTest.suo37.00 kB24-01-08 13:53
TscLibDllTest.vcproj5.66 kB18-01-08 14:04
ReadMe.txt1.04 kB18-01-08 14:03
Form1.resx5.68 kB24-01-08 13:30
AssemblyInfo.cpp1.14 kB18-01-08 14:04
stdafx.cpp159.00 B18-01-08 14:04
stdafx.h171.00 B18-01-08 14:04
app.rc1.22 kB18-01-08 14:04
resource.h91.00 B18-01-08 14:04
app.ico1.05 kB13-12-05 20:51
TscLibDllTest.vcproj.ERNEST.Ernest1.user1.37 kB24-01-08 13:53
TSCLIB.dll92.00 kB06-08-07 11:42
BuildLog.htm10.47 kB24-01-08 13:51
TscLibDllTest.exe.intermediate.manifest380.00 B24-01-08 13:51
mt.dep61.00 B24-01-08 13:51
TscLibDllTest.pch3.13 MB24-01-08 13:51
vc80.pdb220.00 kB24-01-08 13:51
vc80.idb195.00 kB24-01-08 13:51
stdafx.obj15.32 kB24-01-08 13:51
AssemblyInfo.obj6.09 kB24-01-08 13:51
TscLibDllTest.obj691.69 kB24-01-08 13:51
TscLibDllTest.Form1.resources180.00 B24-01-08 13:51
app.res1.18 kB24-01-08 13:51
BuildLog.htm7.70 kB18-01-08 16:28
TscLibDllTest.pch3.13 MB18-01-08 14:32
vc80.pdb132.00 kB18-01-08 16:28
vc80.idb211.00 kB18-01-08 16:28
stdafx.obj11.71 kB18-01-08 14:32
AssemblyInfo.obj4.89 kB18-01-08 14:32
TscLibDllTest.obj49.38 kB18-01-08 16:28
TscLibDllTest.Form1.resources180.00 B18-01-08 15:57
app.res1.18 kB18-01-08 15:57
TscLibDllTest.exe.intermediate.manifest385.00 B18-01-08 16:28
mt.dep61.00 B18-01-08 16:28
Form1.h2.67 kB24-01-08 13:47
TscLibDllTest.cpp2.69 kB24-01-08 13:50
<TscLibDllTest.ilk>0.00 B18-01-08 16:28
TscLibDllTest.pdb243.00 kB18-01-08 16:28
TscLibDllTest.exe46.50 kB18-01-08 16:28
UL.PCX5.11 kB09-05-96 04:49
tsclib.dll40.00 kB24-01-08 13:40
TscLibDllTest.pdb883.00 kB24-01-08 13:51
TscLibDllTest.exe268.00 kB24-01-08 13:51
TscLibDllTest.ncb13.60 MB24-01-08 13:53
<Release>0.00 B24-01-08 13:37
<Debug>0.00 B24-01-08 13:37
<TscLibDllTest>0.00 B24-01-08 13:37
<debug>0.00 B24-01-08 13:37
<release>0.00 B24-01-08 13:37
<TSCLIB.DLL-VC++2005-Example>0.00 B24-01-08 13:37
...
Sponsored links

Comments

(Add your comment, get 0.1 Point)
Minimum:15 words, Maximum:160 words
  • 1
  • Page 1
  • Total 1

ORALCE JOB (4.76 MB)

Need 1 Point(s)
Your Point (s)

Your Point isn't enough.

Get 22 Point immediately by PayPal

Point will be added to your account automatically after the transaction.

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more Points

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D