-
this code for the use of PL/SQL stored procedures development of the database of...
此代码为利用PL/SQL开发数据库存储过程的典型示例,此为第2部分,希望大家可以通过该代码清楚如何利用SQL语句实现复杂的业务逻辑。-this code for the use of PL/SQL stored procedures development of the database of typical examples of this Part 2, We can hope that the adoption of the code clearly how to use SQL to achieve complex business logic.
- 2022-11-29 05:40:03下载
- 积分:1
-
pl/sql中记log的函数,是log4在oracle pl/sql下的办法,比较方便与存储过程的log记录。...
pl/sql中记log的函数,是log4在oracle pl/sql下的办法,比较方便与存储过程的log记录。
- 2022-03-03 03:33:10下载
- 积分:1
-
Produre
很经典的一个produre 存储过程 里面包含的很多东西 一个很完整的存储过程 公司高手所写 很经典值得学习(is very good produce for learn of oracle that is very fearfulness staffer write )
- 2011-12-15 10:36:39下载
- 积分:1
-
4, the preparation of a process. Requirements: have an input parameter and an ou...
4、 编写一个过程。要求:有一个输入参数和一个输出参数,过程里面要有自定义异常。从学生表中(tab_student)中寻找符合指定学号等于输入参数的值,然后将找到的学生的姓名赋予输出参数,如果没有符合条件的值则触发异常。
Create table tab_student
(sno char(8),
sname varchar2(20),
age integer,
province varchar2(60),
sex char(4))
insert into tab_student values(‘001’,’zhou’,20,’江苏徐州’,’男’)
上述表已经创建,只需针对此表编写即可。
-4, the preparation of a process. Requirements: have an input parameter and an output parameter, the process which must be custom exception. From the student table (tab_student) to find places to comply with the specified number of values equal to the input parameters, and then will find the names of the students entrusted to output parameters, if there is no eligible trigger abnormal value. Create table tab_student (sno char (8), sname varchar2 (20), age integer, province varchar2 (60), sex char (4)) insert into tab_student values (
- 2022-04-19 01:29:02下载
- 积分:1
-
oracle
Oracle错误代码集合
ORA-17001=内部错误
ORA-17002=Io 异常
ORA-17003=无效的列索引
ORA-17004=无效的列类型
ORA-17005=不支持的列类型
ORA-17006=列名无效
ORA-17007=无效的动态列
ORA-17008=关闭的连接
ORA-17009=关闭的语句
ORA-17010=关闭的 Resultset
- 2022-05-27 15:45:36下载
- 积分:1
-
windows2000server打震荡波补丁后导致ORACLE8i不能自动启动数据库服务的解决办法...
windows2000server打震荡波补丁后导致ORACLE8i不能自动启动数据库服务的解决办法-windows2000server fight Sasser patch ORACLE8i not automatically lead to start the database service solutions
- 2022-02-02 22:24:29下载
- 积分:1
-
Oracle_RDA
RDA英文全称叫做“Oracle Remote Diagnostic Agent”。
这个Oracle诊断工具是用perl编写的,包含非常丰富的诊断脚本,使用它可以非常便利的采集到Oracle数据库服务器系统配置和数据库的详细信息。
如果您在向Oracle支持人员寻求帮助时能够提供一份RDA报告,将会大大的缩短问题处理的周期,避免信息的反复采集。
RDA不会更改数据库服务器的任何配置,仅仅是采集信息,了解系统。(RDA English name called Oracle Remote Diagnostic Agent .
The Oracle diagnostic tool is written in Perl, including diagnostic script is very rich, detailed information can use it very convenient acquisition to the Oracle server configuration and system.
If you can provide a RDA report to Oracle support staff for help, it will greatly shorten the treatment cycle, avoid repeated acquisition information. Any configuration of RDA does not change the server, just collect the information, understand the system.)
- 2015-01-19 13:45:37下载
- 积分:1
-
一个连接池源码,非常好用!创建一个cf,然后cf.getconn()就可以得到空闲连接,可以设置最大最小连接数...
一个连接池源码,非常好用!创建一个cf,然后cf.getconn()就可以得到空闲连接,可以设置最大最小连接数-a connection pool source, a very handy! Create an cf, then cf.getconn () can be idle connections, to set the maximum number of the smallest link
- 2022-07-08 06:08:34下载
- 积分:1
-
Functions
这里我举函数的例子。如何在pl/sql中创建函数和调用函数
- 2022-07-11 12:53:45下载
- 积分:1
-
Demonstrates OCCI Advanced Queuing(AQ) interface (10g)
Demonstrates OCCI Advanced Queuing(AQ) interface (10g)
- 2022-01-21 05:08:01下载
- 积分:1