-
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-basic
Oracle数据库系统是目前世界上流行的关系数据库管理系统,系统可移植性好、使用方便、功能强,适用于各类大、中、小、微机环境。(Oracle system is the world s popular relational management system, system portability is good, easy to use, powerful, suitable for all types of large, medium and small, computer environment.)
- 2016-10-08 14:44:59下载
- 积分:1
-
OpenSocial的源代码,以显示阅读现状
opensocial源代码,可以显示读书状态-opensocial source code, to show reading status
- 2022-03-20 02:34:20下载
- 积分:1
-
oracle
oracle数据库的学习资料,分为4天的内容,非常详细、实用(learning materials oracle database is divided into four days of content, very detailed, practical)
- 2013-12-25 23:06:35下载
- 积分:1
-
基于Java的贵美商城的设计与实现
该系统为Java Web项目,该系统为网上购物项目,用户可以通过注册实现登录,购买,添加商品,删除商品,浏览商品等功能,后台数据库为Oracle,前端运用html/css,Js,Jquery,Ajax,等技术开发。
- 2022-05-12 12:39:54下载
- 积分:1
-
本源代码实现同时对数据库Oracle和MS SQL的连接,通过对配置文件的修改来实现,本代码执行生产为dll文件。...
本源代码实现同时对数据库Oracle和MS SQL的连接,通过对配置文件的修改来实现,本代码执行生产为dll文件。-source code to the database simultaneously Oracle and MS SQL connectivity, the configuration file through changes to achieve the production code execution dll file.
- 2022-01-28 02:45:00下载
- 积分:1
-
complete reference ebook for oracle version 10 G. Book is descriptive and easy t...
complete reference ebook for oracle version 10 G. Book is descriptive and easy to refer.
- 2022-04-12 10:27:56下载
- 积分:1
-
c# written oracle import excel source.
c#写的excel导入oracle源码。-c# written oracle import excel source.
- 2023-03-02 10:25:03下载
- 积分:1
-
封装oci的java实现类调用实例
可以用于jsp开发中。
封装oci的java实现类调用实例
可以用于jsp开发中。-Packaging oci java achieve the category called examples can be used jsp development.
- 2022-02-25 02:15:02下载
- 积分:1
-
TransForm
一个通用的数据库转换数据,实现了sqlserver,sybase,oracle数据库进行数据转换(A general conversion data to achieve the essentially, sybase, oracle data conversion)
- 2014-11-06 22:27:08下载
- 积分:1