-
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
-
expert_oracle_goldengate
Oracle Corporation acquired GoldenGate in 2009 as part of future strategy to implement advanced
replication technologies within the product suite of data warehousing and real-time transaction
management. Before the advent of Oracle GoldenGate technology, data replication was performed using
Oracle Streams and third-party replication solutions such as Quest SharePlex. This chapter discusses
various types of database replication methods along with the techniques used by each method, to
illustrate how Oracle GoldenGate came to be the logical conclusion for the current and future real-time-
based data-transaction replication technology with Oracle database systems.
- 2013-10-23 17:28:47下载
- 积分:1
-
java链接ORaCLe 数据库,这需要JAR包,可以判断你是否连接上你的ORACLE,可以写上简单的数据测试一下....
java链接ORaCLe 数据库,这需要JAR包,可以判断你是否连接上你的ORACLE,可以写上简单的数据测试一下.-JAVAconeect the database of oracle of code.
- 2022-02-22 03:41:53下载
- 积分:1
-
9iDBA1_1
Oracle 9i 1.0.2.1 pdf DBA 11
- 2009-11-12 17:11:15下载
- 积分:1
-
OracleHelper
访问oracle数据的与C#接口,在C#中如何连接oracle数据库,访问存储过程,批量更新数据库等(Oracle data access with C# interface, in C# how to connect oracle database, visit the stored procedure, update the database, such as bulk)
- 2009-03-24 12:28:45下载
- 积分:1
-
甲骨文公司
Oracle-by-tom,tom 大师,值得学习。-Oracle-by-tom
- 2022-08-08 10:39:01下载
- 积分:1
-
数据库操作辅助工具类
整理了一些数据库的相关工具,这样来凝结数据库,进行增删改查等等就都可以直接调用,非常方便。
- 2022-07-28 04:21:54下载
- 积分:1
-
p8670579_112010_LINUX
ORACLE安装所需补丁包,解压后使用。。。。。(ORACLE Installation Required Patch Pack, After Decompression, Use)
- 2020-06-21 15:20:02下载
- 积分:1
-
Oracle GeoRaster 开发手册
Oracle GeoRaster 开发手册-Oracle GeoRaster Development Manual
- 2022-05-29 17:41:43下载
- 积分:1
-
用ADO进行数据访问的例子,这里主要提供了对数据库里BLOB的访问方法。...
用ADO进行数据访问的例子,这里主要提供了对数据库里BLOB的访问方法。-with ADO data access for example, where the main provider of database BLOB visit methods.
- 2022-08-07 07:15:10下载
- 积分:1