-
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
-
we learn advanced experience of other provinces and cities on the basis of mater...
我们在学习外省市先进经验的基础上，结合教材管理工作实际情况和多年的工作经验，组织了专门人员与协力电脑公司利用Vb6.0程序语言和SQL数据库语言共同开发研制了“河北广播电-we learn advanced experience of other provinces and cities on the basis of materials management with the actual situation, and many years of work experience, organized with the help of specialized personnel computer companies use Vb6.0 programming language and SQL database language jointly developed "Hebei Radio
- 2022-03-21 22:50:04下载
- 积分：1
-
hope that we can enlighten a lot to me this is part of our classmates system
希望大家能多多指教这是我给我们同学编的系统-hope that we can enlighten a lot to me this is part of our classmates system
- 2023-01-13 04:55:05下载
- 积分：1
-
初学者的源c代码，一共5个，主要是c基础,包括文件操作。
初学者的源c代码，一共5个，主要是c基础,包括文件操作。-c beginners source code, a total of five, mainly c base, including file operations.
- 2022-06-13 13:15:02下载
- 积分：1
-
算法艺术与信息学竞赛.pdf,仅供大家参考。
算法艺术与信息学竞赛.pdf,仅供大家参考。-Algorithm art and informatics competitions. Pdf, for your reference.
- 2022-04-15 13:56:11下载
- 积分：1
-
PB制作考试系统
PB制作考试系统-PB production test system
- 2023-01-28 21:00:04下载
- 积分：1
-
use of the C language Part 24 small game, in the C language can be run directly.
利用C语言编的二十四点小游戏，在C语言下可直接运行。-use of the C language Part 24 small game, in the C language can be run directly.
- 2022-08-26 06:01:06下载
- 积分：1
-
fifo和lru页面置换算法
fifo和lru页面置换算法-fifo and LRU algorithm replacement pages
- 2023-03-26 10:20:03下载
- 积分：1
-
如何使用水晶报表
how to use crystal report
- 2022-03-19 06:53:08下载
- 积分：1
-
队列相关的所有基本算法，西电的老师写的，与吴伟民数据结构课本完全一致，用C实现...
队列相关的所有基本算法，西电的老师写的，与吴伟民数据结构课本完全一致，用C实现-cohort of all the basic algorithm, the West-- written by the teachers, and textbooks Xiulan WU Weimin data structure is fully consistent with achieving C
- 2022-03-07 14:35:04下载
- 积分：1
