-
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
-
严蔚敏编写的《数据结构》第6章的答案,全部为源码
严蔚敏编写的《数据结构》第6章的答案,全部为源码-the answers of chapter 6 of a book called ‘Data Structures’ writen by Yan Wei Min
- 2022-10-03 12:50:03下载
- 积分:1
-
在一个圆形操场的四周摆放着n堆石子。现要将石子有次序地合并成一堆。规定每次只能选相邻的两堆石子合并成新的一堆,并将新的一堆石子数记为该次合并的得分。试设计一个算...
在一个圆形操场的四周摆放着n堆石子。现要将石子有次序地合并成一堆。规定每次只能选相邻的两堆石子合并成新的一堆,并将新的一堆石子数记为该次合并的得分。试设计一个算法,计算出将n堆石子合并成一堆的最小得分和最大得分,并分析算法的计算复杂度。-in a circle around the playground are placed n gravel pile. Is a stone should order to be merged into a heap. Stipulated that only elected adjacent to the pile of gravel into the new heap, and a new pile of gravel credited for the combined scores. Design a test algorithm to calculate n heap into a pile of gravel to the minimum score and the biggest score and analysis of algorithm complexity.
- 2022-03-22 21:40:18下载
- 积分:1
-
Delphi2005数据库开发教程.rar
Delphi2005数据库开发教程.rar-Delphi2005shujukukaifa
- 2022-08-16 10:28:44下载
- 积分:1
-
At 0 and 1 backpack case for problem
在0和1情况下进行背包问题解决,涉及多个物体的重量和价值,求得最大价值量以及分配方案。-At 0 and 1 backpack case for problem-solving, involving more than the weight of objects and values, as well as to achieve maximum value distribution program.
- 2022-02-01 11:38:47下载
- 积分:1
-
后台输出
实现冒泡排序、插入排序、shell排序、快速排序、堆排序等经典排序算法,并对每个排序算法的代码行进行注释说明
- 2023-02-19 01:40:03下载
- 积分:1
-
数据结构二叉树的源码
数据结构二叉树的源码-binary tree data structure FOSS
- 2023-01-19 08:50:03下载
- 积分:1
-
网上收集的关于各种算法的各种讨论
网上收集的关于各种算法的各种讨论-online collection of the various algorithms discussed
- 2022-12-22 16:00:03下载
- 积分:1
-
栈的操作和应用分隔符匹配检验主管…
栈的操作与应用
定界符配对检查
中缀转后缀并求值-stack operation and application delimiter matching inspection superintendent to seek value and Suffix
- 2022-07-06 21:41:57下载
- 积分:1
-
实现md5文件电子签名,md5hash值计算,比较文件,自己可扩展功能实现几个文件对比,从而找出重复文件...
实现md5文件电子签名,md5hash值计算,比较文件,自己可扩展功能实现几个文件对比,从而找出重复文件-Md5 files to achieve electronic signature, md5hash calculated to compare documents, they can extend the functionality to achieve a number of document comparison, and to find duplicate files
- 2022-02-02 15:59:33下载
- 积分:1