登录
首页 » Oracle » 4, the preparation of a process. Requirements: have an input parameter and an ou...

4, the preparation of a process. Requirements: have an input parameter and an ou...

于 2022-04-19 发布 文件大小:994.00 B
0 192
下载积分: 2 下载次数: 1

代码说明:

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 (

下载说明:请别用迅雷下载,失败请重下,重下不扣分!

发表评论

0 个回复

  • 使用的批处理文件,实现了甲骨文的自动备份,具有动态功能…
    利用DOS批处理文件实现oracle自动备份,具有动态创建备份目录功能-use of DOS batch file to achieve oracle automatic backup, has a dynamic function to create backup directories
    2022-01-25 19:53:35下载
    积分:1
  • 1
    说明:  数据库插入的典型方法 工具类方便于以后操作(Database insert)
    2016-10-08 20:47:50下载
    积分:1
  • oracle 程序员开发指南,介绍ORACLE的开发方法
    oracle 程序员开发指南,介绍ORACLE的开发方法-oracle programmer to develop guidelines to introduce the ORACLE Development Approach
    2023-03-14 05:35:04下载
    积分:1
  • Oracle数据库,在C++中使用连接池实现高
    oracle 数据库,在C++中用连接池实现高速连接与访问。-oracle database, in the C++ using connection pooling to achieve high-speed connectivity and access.
    2022-08-21 12:50:54下载
    积分:1
  • 常用SQL查询 包括表空间、日志、控制文件、参数文件、事务提交状态等 非常有用...
    常用SQL查询 包括表空间、日志、控制文件、参数文件、事务提交状态等 非常有用-including commonly used SQL table space, log, document control, parameter document, the Panel submitted to the state as very useful
    2023-02-19 20:25:03下载
    积分:1
  • oracle基础学习文档,主要讲解了oracle一些基本应用与数据库管理。...
    oracle基础学习文档,主要讲解了oracle一些基本应用与数据库管理。-orcale
    2022-01-26 04:42:45下载
    积分:1
  • 数据库底层封装接口
    此开源代码设计数据库oracle和TimesTen的接口封装,涉及消息队列、共享内存、信号量、socket等底层系统函数的接口封装,此接口已经在电信计费系统上正式使用,可放心使用
    2022-04-17 14:52:08下载
    积分:1
  • oracle期末考试简答题
    有关oracle基础知识,oracle11g相关的知识,考试中需要考的,方便需要的人复习oracle的考试,需要的可以下载看看,会对你很有帮助,主要是oracle的简答题,适用于java、c#等程序的编写理论支撑
    2023-03-27 10:20:03下载
    积分: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
  • JSP页面和Oracle9i数据库的源代码
    JSP页面和oracle9i数据库的源代码-JSP pages and Oracle9i database source code
    2022-03-10 04:26:21下载
    积分:1
  • 696516资源总数
  • 106648会员总数
  • 8今日下载