-
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
-
Sysnc
数据库同步程序,能够自动更新远程数据库与本地数据库数据,保持同步。(Database synchronization program to automatically update the remote database with local database data, and to keep pace.)
- 2013-03-21 14:56:19下载
- 积分:1
-
搬家预约
简单的搬家预约系统,只是客户端的简单使用,后期继续完善
简单的搬家预约系统,只是客户端的简单使用,后期继续完善
简单的搬家预约系统,只是客户端的简单使用,后期继续完善
简单的搬家预约系统,只是客户端的简单使用,后期继续完善
- 2022-04-24 17:09:11下载
- 积分:1
-
test with OLE DB provider of a procedure. To test the OEL DB providers to achiev...
用测试OLE DB提供者的一个程序。能够测试出OEL DB提供者到底实现了哪些接口?很灵的。-test with OLE DB provider of a procedure. To test the OEL DB providers to achieve what in the end interface? Very souls.
- 2022-08-12 17:19:19下载
- 积分:1
-
technical manual for beginners, such as the development of a useful reference
oracle技术手册供初学者,开发者等有参考作用-technical manual for beginners, such as the development of a useful reference
- 2023-05-03 11:05:04下载
- 积分:1
-
Oracle Pro*C动态SQL示例C源。
Oracle PRO*C dynamic SQL sample with C source.
- 2022-03-25 00:41:23下载
- 积分:1
-
oracle9i程序事例集,包括oracle9i数据库和jsp页面
oracle9i程序事例集,包括oracle9i数据库和jsp页面-Oracle9i instances procedures, including Oracle9i database and jsp page
- 2022-03-18 23:05:58下载
- 积分:1
-
Lyrics Editing System Developed in NetBeans 6.5
Lyrics Editing System Developed in NetBeans 6.5
- 2022-01-25 20:15:37下载
- 积分:1
-
为了得到最大的性能,一般数据库都有并发机制,不过带来的问题就是数据访问的冲突。为了解决这个问题,大多数数据库用的方法就是数据的锁定....
为了得到最大的性能,一般数据库都有并发机制,不过带来的问题就是数据访问的冲突。为了解决这个问题,大多数数据库用的方法就是数据的锁定.-In order to get the maximum performance, a general mechanism for the database have complicated, but the problem is caused by data access conflicts. To solve this problem, the majority of the database is used to lock data.
- 2022-08-22 11:21:22下载
- 积分:1
-
用VB实现连接oracle817数据月报数输入并统计
用VB实现连接oracle817数据月报数输入并统计-connect with VB oracle817 Monthly data input and few statistics
- 2022-07-10 21:11:56下载
- 积分:1