-
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
-
data structure large operations Experimental Report
数据结构大型作业实验报告-哈夫漫-data structure large operations Experimental Report-Halff Man
- 2022-03-19 00:17:50下载
- 积分:1
-
这是用QB编的排序程序。利用条形显示冒泡排序、快速排序、等五种排序方法。 效果一流,对于C语言,数据结构爱好者是不错的选择。...
这是用QB编的排序程序。利用条形显示冒泡排序、快速排序、等五种排序方法。 效果一流,对于C语言,数据结构爱好者是不错的选择。-This is the sort made by QB procedures. Strip shows that the use of Bubble Sort, Quick Sort, five sorting method. The effect of first-class, for C language, data structure enthusiasts is a good choice.
- 2022-06-15 06:19:40下载
- 积分:1
-
bankers algorithm can solve computer's operating system Mutex. There are oth...
银行家算法可以解决计算机操作系统里的互斥。还有peterson等其他算法-bankers algorithm can solve computer"s operating system Mutex. There are other algorithms Peterson
- 2022-05-26 01:17:52下载
- 积分:1
-
主要介绍了如何使用SQL语言编写高效简洁的数据库编程语句,提高数据库编程思想...
主要介绍了如何使用SQL语言编写高效简洁的数据库编程语句,提高数据库编程思想-Introduces how to use the SQL language simple and efficient database programming language, database programming to improve thinking
- 2022-03-13 08:18:47下载
- 积分:1
-
利用栈和队列完成停车场的管理,数据结构的实习题目,并完成选做内容...
利用栈和队列完成停车场的管理,数据结构的实习题目,并完成选做内容-use stack and queue complete parking management, and data structure of the internship topics, and complete the election to content
- 2022-05-13 11:31:35下载
- 积分:1
-
在 php 中的网站类
在我的教室里,我学会了如何在 php 中使类。这就像在其他语言中的类。所以我分享我的课堂学习。
- 2022-08-07 21:33:00下载
- 积分:1
-
AOV topological sorting algorithm
AOV的拓扑排序算法-AOV topological sorting algorithm
- 2022-05-26 12:02:06下载
- 积分:1
-
同一个数据库开发的系统,里面有源代码和发布版本
同一个数据库开发的系统,里面有源代码和发布版本-with a database development systems, which Active code and releases
- 2022-03-08 08:46:26下载
- 积分:1
-
建立带表头结点的单链表,打印所有结点的数据域;输入一个值,若某个结点的数据域为该值,则在其后插入另一个新结点,若无此结点,则在表尾插入新结点,然后打印;给一个值...
建立带表头结点的单链表,打印所有结点的数据域;输入一个值,若某个结点的数据域为该值,则在其后插入另一个新结点,若无此结点,则在表尾插入新结点,然后打印;给一个值,删除结点的数据域是该值的所有结点,然后打印。(表生成时可用前插法或后插法)-table with the establishment of the first node of a single linked list, print all nodes of the data domain; An input value, If a node"s data fields for the values, and subsequently inserted in a new node, in the absence of such nodes, at the end of the insertion of a new form nodes, then Print; to a value of the node to delete data domain is the value of all the nodes, then Print. (Table Generation available houses or after interpolation)
- 2023-01-23 20:10:04下载
- 积分:1