-
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
-
学校信息系统
这项计划是包括招生过程中,搜索某一特定记录的学生和修改和更新的记录和该程序还提供了 2 份报告的学生。
- 2023-02-21 20:20:03下载
- 积分:1
-
这是关于01背包问题的动态规划算法。采用C++语言完成的,代码间有注释。...
这是关于01背包问题的动态规划算法。采用C++语言完成的,代码间有注释。-This is about 01 knapsack problem dynamic programming algorithm. Using C++ language completed, there are comments between the code.
- 2023-04-07 01:55:02下载
- 积分:1
-
数据结构c++版程序
数据结构c++版程序-data structure c editions
- 2022-01-26 03:38:31下载
- 积分:1
-
DELPHI Department of Computer Science, Academic Management System, with paper de...
DELPHI计算机科学系教务管理系统,带论文设计,不错的参考-DELPHI Department of Computer Science, Academic Management System, with paper design, a good reference
- 2022-02-12 15:29:56下载
- 积分:1
-
This is a server
这是聊天系统的服务器端,它控制客户端程序的登录和连接,采用ACCE-This is a server-side chat system, which controls the client program to log in and connect, using ACCE
- 2023-07-13 02:20:02下载
- 积分:1
-
development environment : c builder6.0 SQL server
开发环境:c++builder6.0 SQL server2-development environment : c builder6.0 SQL server
- 2022-03-11 18:31:07下载
- 积分:1
-
实现heap排序的算法,首先把Heap建立起来,然后通过对Heap的根节点来找出当前最小的节点,依次就可以实现排序了。...
实现heap排序的算法,首先把Heap建立起来,然后通过对Heap的根节点来找出当前最小的节点,依次就可以实现排序了。-achieve heap sorting algorithm to first establish Run, then Run right through the current nodes to identify the smallest nodes can be followed to achieve the ranking.
- 2023-04-22 02:25:03下载
- 积分:1
-
connection/object pool. A program may require a IMAP connection po ol and LDAP c...
Many applications use connection/object pool. A program may require a IMAP connection pool and LDAP connection pool. One could easily implement a IMAP connection pool, then take the existing code and implement a LDAP connection pool. The program grows, and now there is a need for a pool of threads. So just take the IMAP connection pool and convert that to a pool of threads (Copy, paste, find, replace????). Need to make some changes to the pool implementation? Not a very easy task, since the code has been duplicated in many places. Re-inventing source code is not an intelligent approach in an object oriented environment which encourages re-usability. It seems to make more sense to implement a pool that can contain any arbitrary type rather than duplicating code. How does one do that? The answer is to use type parameterization, more commonly referred to as templates.-connection/object pool. A program may require a IMAP connection po ol and LDAP connection pool. One could easily im plemen
- 2023-05-15 08:25:03下载
- 积分:1
-
病人管理系统
病人管理系统是用来保持病人预约和病史。
- 2022-02-15 00:20:35下载
- 积分:1