-
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;
- 2022-01-25 20:02:48下载
- 积分:1
-
An ACCESS database on VC6.0 with the combination of examples of small programs
一个有关VC6.0与数据库为ACCESS结合的小程序例子-An ACCESS database on VC6.0 with the combination of examples of small programs
- 2022-03-16 14:15:06下载
- 积分:1
-
用VB+access数据库设计的学生公寓管理信息系统.有一定实用参考价值!...
用VB+access数据库设计的学生公寓管理信息系统.有一定实用参考价值!-VB access database design student apartment management information systems. Have practical value!
- 2022-09-07 23:55:03下载
- 积分:1
-
一个很好的通讯录管理系统
一个很好的通讯录管理系统-a very good correspondence management system
- 2022-01-25 17:17:43下载
- 积分:1
-
动态加载odbc数据源及其内部表单的小程序
动态加载odbc数据源及其内部表单的小程序-Dynamic loading odbc data source and its internal form of small programs
- 2022-09-04 08:50:02下载
- 积分:1
-
一些常用的几何算法的C++实现,包括两点确定一条直线,两点间距离,点直线距离, 海伦公式求三角形面积,判断直线相交等...
一些常用的几何算法的C++实现,包括两点确定一条直线,两点间距离,点直线距离, 海伦公式求三角形面积,判断直线相交等-some common geometric algorithm C achieved, including two identified a straight line, the distance between two points, point straight distance Helen formula for triangle area, as judged straight intersection
- 2022-06-27 00:57:26下载
- 积分:1
-
Rome dominated the number of algorithms, on the generalized Petersen graph P (n,...
罗马支配数的算法,对广义Petersen图P(n,2)的罗马支配数进行了研究-Rome dominated the number of algorithms, on the generalized Petersen graph P (n, 2) the number of Roman domination of the research
- 2022-02-04 22:11:59下载
- 积分:1
-
是一个很不错的软件噢
是一个很不错的软件噢-is a very good software Oh
- 2022-06-19 16:07:07下载
- 积分:1
-
数据结构中图的相关操作,数据结构中图的相关操作
数据结构中图的相关操作,数据结构中图的相关操作-data structure of the plan related operations, data structure of the plan related to operation
- 2023-09-03 08:05:03下载
- 积分:1
-
算法是一种字符串匹配算法!源代码介绍…
bm算法是串的一种匹配算法!本源代码介绍了bm算法的c实现。-bm algorithm is a string matching algorithm! Source code introduced bm Algorithm c achieve.
- 2023-05-22 10:20:03下载
- 积分:1