-
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 ADF demo
一个非常实用的Oracle ADF案例,项目全周期资金计划
- 2023-05-15 18:20:04下载
- 积分:1
-
www.programsalon.com
www.programsalon.com
- 2023-05-19 14:55:03下载
- 积分:1
-
This is Online Student Management System which used JDeveloper and Oracle togeth...
This Online Student Management System which used JDeveloper and Oracle together.-This is Online Student Management System which used JDeveloper and Oracle together.
- 2022-05-15 16:28:56下载
- 积分:1
-
oracle 程序员开发指南,介绍ORACLE的开发方法
oracle 程序员开发指南,介绍ORACLE的开发方法-oracle programmer to develop guidelines to introduce the ORACLE Development Approach
- 2023-03-14 05:35:04下载
- 积分:1
-
AccessOracleInDotNET
在DOTNET环境中访问Oracle数据库的方法实例,使用CSharp语言(In DOTNET environment visit Oracle database instance, use CSharp Language)
- 2008-02-02 14:20:29下载
- 积分:1
-
让ACCESS删除记录后自动排序字段不断号,解决自动编号删除数据后不自动向上移而间隔了删除的ID问题...
让ACCESS删除记录后自动排序字段不断号,解决自动编号删除数据后不自动向上移而间隔了删除的ID问题-Let ACCESS automatically delete record No. sorting field continuously to address the automatic code does not delete data automatically up-shift and delete the ID of the interval problem
- 2022-01-30 22:39:57下载
- 积分:1
-
c# written oracle import excel source.
c#写的excel导入oracle源码。-c# written oracle import excel source.
- 2023-03-02 10:25:03下载
- 积分:1
-
vb编写com读取电表
使用vb编写一个读取串口的电表
开始要在已经设计好的界面添加各种控件,来和端口进行通讯,也可以编辑指令代码来传送信息。
设定好MScomm控件初始时的各种条件,端口为3,波特率为9600,停止位为1,校验位为even,数据位为8,端口初始状态为打开
- 2022-03-13 14:40:34下载
- 积分:1
-
Oracle所有的位图索引
all about oracle bitmap index
- 2022-07-12 11:13:38下载
- 积分:1