-
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
-
Kruskal算法寻找最小生成树,C语言实现,有完整的注释!
Kruskal算法寻找最小生成树,C语言实现,有完整的注释!-Kruskal finding minimum spanning tree algorithm, C Language, a complete Notes!
- 2022-07-23 02:10:48下载
- 积分:1
-
北大ACM1003(Hangover)
北大ACM1003(Hangover)-North ACM1003 (Hangover)
- 2022-02-03 12:26:03下载
- 积分:1
-
poj1125 binary heap using the Dijkstra algorithm optimization
poj1125用二叉堆优化的Dijkstra算法-poj1125 binary heap using the Dijkstra algorithm optimization
- 2022-07-15 13:25:37下载
- 积分:1
-
ADO直接读取数据库的编程实例
ADO直接读取数据库的编程实例-read directly ADO database programming examples
- 2022-03-29 12:09:20下载
- 积分:1
-
一元稀疏表达式计算器 大学数据结构实验,关于线性表的实验题目,我的作品,如有问题发邮件给我...
一元稀疏表达式计算器 大学数据结构实验,关于线性表的实验题目,我的作品,如有问题发邮件给我-one yuan sparse expression calculator University experimental data structure on the linear scale experimental subject, my work, and if made to the mail I
- 2023-07-23 08:40:03下载
- 积分:1
-
统计字符出现的频率的哈夫曼编码
统计字符出现的频率的哈夫曼编码-the frequency of Huffman coding
- 2022-01-24 16:36:21下载
- 积分:1
-
封装了数据库的基本操作,再也不用为写esql的程序烦恼了,很方便
封装了数据库的基本操作,再也不用为写esql的程序烦恼了,很方便-package of the basic operation of the database, no longer have to write esql procedures trouble. Very convenient
- 2022-07-20 20:37:26下载
- 积分:1
-
java of several commonly used sorting algorithm. Using Java language to achieve...
java中几种常用的排序算法。
用Java语言实现的各种排序,包括插入排序、冒泡排序、选择排序、Shell排序、快速排序、归并排序、堆排序、SortUtil等。-java of several commonly used sorting algorithm. Using Java language to achieve a variety of sorting, including the Insertion Sort, Bubble Sort, Selection Sort, Shell Sort, Quick Sort, Merge Sort, Heap Sort, SortUtil such.
- 2022-12-16 21:50:04下载
- 积分:1
-
数据结构编程源代码
数据结构编程源代码- Construction of data programming source code
- 2023-04-05 11:55:03下载
- 积分:1