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

-免费票状态修改 需修改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;

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.ilk0.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
Release0.00 B24-01-08|13:37
Debug0.00 B24-01-08|13:37
TscLibDllTest0.00 B24-01-08|13:37
debug0.00 B24-01-08|13:37
release0.00 B24-01-08|13:37
TSCLIB.DLL-VC++2005-Example0.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