-
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
-
java 数据库 功能强大 效率高
SmallSQL Database is a free DBMS library for the Java(tm) pl...
java 数据库 功能强大 效率高
SmallSQL Database is a free DBMS library for the Java(tm) platform. It runs
on the Java 2 Platform (JDK 1.4 or later) and implements the JDBC 3.0 API.
SmallSQL Database is licensed under the terms of the GNU Lesser General
Public Licence (LGPL). A copy of the licence is included in the
distribution.
Please note that SmallSQL Database is distributed WITHOUT ANY WARRANTY
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE. Please refer to the licence for details.-java a powerful and efficient database SmallSQL Database is a free DBMS library for the Java (tm) platform. It runs on the Java 2 Platform (JDK 1.4 or later) and implements the JDBC 3.0 API.SmallSQL Database is licensed under the terms of the GNU Lesser GeneralPublic Licence (LGPL). A copy of the licence is included in thedistribution.Please note that SmallSQL Database is distributed WITHOUT ANY WARRANTY without even the implied warranty of MERCHANTAB
- 2022-01-26 02:33:06下载
- 积分:1
-
仓库管理系统,是一个很实用的管理系统!请大家
仓库管理系统,是一个很实用的管理系统!请大家-Warehouse Management System, is a very useful management system! Please everyone
- 2022-07-12 12:38:18下载
- 积分:1
-
数据结构c语言版,图的遍历,周游世界,无向图的遍历,包含14个国家。...
数据结构c语言版,图的遍历,周游世界,无向图的遍历,包含14个国家。-Data structure c language version, graph traversal, travel around the world, undirected graph traversal, including 14 countries.
- 2022-08-18 21:58:53下载
- 积分:1
-
Divided ideological merge sort is very important sub
分治的思想
归并排序
分治是很重要的方法
归并排序是一种快速的排序-Divided ideological merge sort is very important sub-rule method is a quick sort merge sort
- 2022-03-14 12:53:38下载
- 积分:1
-
“数据结构、算法和程序”这个抽象世界的特殊旅程,以解决现实生活中的许多难题...
“数据结构、算法和程序”这个抽象世界的特殊旅程,以解决现实生活中的许多难题- Data structures, algorithms and procedures of the abstract world of a special journey to solve many real-life problems
- 2023-03-03 18:00:06下载
- 积分:1
-
我自己写的数值分析课程设计的源代码,这里是数值插值算法的内容。...
我自己写的数值分析课程设计的源代码,这里是数值插值算法的内容。-I wrote it myself numerical analysis courses designed source code, here is the interpolation algorithm for the numerical content.
- 2022-03-16 09:21:16下载
- 积分:1
-
Dijkstra algorithm, has been established for finding the shortest path map is a...
dijkstra算法,用于寻找已建立图的最短路径,是非常有用的一个算法-Dijkstra algorithm, has been established for finding the shortest path map is a very useful algorithm
- 2023-02-06 10:15:04下载
- 积分:1
-
算符优先函数
设计一个给定算符优先分析表,用有向图法构造算符优先函数的算法。...
算符优先函数
设计一个给定算符优先分析表,用有向图法构造算符优先函数的算法。-Operator to design a priority function given priority operator analysis table, and have to graph structure function operator priority algorithms.
- 2022-02-02 22:16:24下载
- 积分:1
-
C#与.net4.0数据库开发书源程序
C#与.net4.0数据库开发书源程序第一章
- 2022-08-24 01:37:22下载
- 积分:1