Search - exception

Search - exception - List

[Oracle] 1 DL : 0: 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 (
Date : 2026-01-03 Size : 1kb User : 哈哈
[Oracle] SQL DL : 0: oracle数据库游标，函数，过程，异常等等小程序，可供大家参考一下-oracle database, cursor, function, process, exception, etc. applet, for your reference
Date : 2026-01-03 Size : 8kb User : along
[Oracle] Oracle_Trigger_Stored_Procedure DL : 0: 用Oracle有效地创建和管理大型数据库！数据库专家Kevin Owens是美国财政部计算机中心的Oracle数据库管理员，他将与您共同探讨PL/SQL——Oracle的结构化查询语言（SQL），并教您如何通过构建健壮、大型的数据库来解决您的业务问题。《Oracle触发器与存储过程高级编程(第3版)》语言通俗易懂，并引入大量代码示例。书中详细介绍了许多技术来利用Oracle的特性，如触发器和存储过程等。这些特性支持数据库结合业务规则，并可以根据业务的发展变化对规则进行管理和修改。本书讨论的主题包括：· 查看数据字典中的约束· 实施复杂的规则· PL/SQL程序单元和语言特性· 数据类型和复合结构· 错误处理和异常· 进程间的通信· 声明性约束，包括主键约束、惟一性约束、外键约束和检查约束等本书对于希望构建和维护智能化大型数据库的开发人员、设计人员和项目负责人来说，都是不可多得的宝贵资源。-With Oracle to efficiently create and manage large database! Database expert Kevin Owens is the U.S. Treasury Department s Oracle database administrator computer center, he will work with you to discuss PL/SQL- Oracle s Structured Query Language (SQL), and teach you how to build robust, large databases to solve your business problems. "Oracle triggers and stored procedures advanced programming (3rd edition)" language easy to understand, and to introduce a large number of code examples. The book details the many techniques to take advantage of Oracle features such as triggers and stored procedures. These features combined with business rules to support the database and may change based on the development of business rules to manage and modify. Topics discussed in this book include: the constraints in the data dictionary view to implement the complex rules of PL/SQL program units and language features composite structure, data types and exception error handling and inter-process communic
Date : 2026-01-03 Size : 29.2mb User :
[Oracle] Oracleprocedure DL : 0: 存储过程基础培训。如何进行异常处理。如何进行事务处理。如何优化存储过程。-Stored procedure based training. How to exception handling. How the transaction. How to optimize stored procedures.
Date : 2026-01-03 Size : 67kb User : lixiaoyi
[Oracle] oracle DL : 0: Oracle 存储过程 1 Oracle存储过程基础知识 1 Oracle存储过程的基本语法 2 关于Oracle存储过程的若干问题备忘 4 1. 在Oracle中，数据表别名不能加as。 4 2. 在存储过程中，select某一字段时，后面必须紧跟into，如果select整个记录，利用游标的话就另当别论了。 5 3. 在利用select...into...语法时，必须先确保数据库中有该条记录，否则会报出 no data found 异常。 5 4. 在存储过程中，别名不能和字段名称相同，否则虽然编译可以通过，但在运行阶段会报错 5 5. 在存储过程中，关于出现null的问题 5 6. Hibernate调用Oracle存储过程 6 用Java调用Oracle存储过程总结 6 一、无返回值的存储过程 6 二、有返回值的存储过程（非列表） 8 三、返回列表 9 在存储过程中做简单动态查询 11 一、本地动态SQL 12 二、使用DBMS_SQL包 13 Oracle存储过程调用Java方法 16 Oracle高效分页存储过程实例 17- The Oracle stored procedure 1 Basic knowledge of Oracle stored procedure 1 2 the Oracle stored procedure of the basic grammar Several problems about the Oracle stored procedure memo 4 1. In Oracle, alias added as data table. 4 2. In the process of storage, a field, must follow into behind, if the entire record, using a cursor is another matter. 5 3. In the use of the select... Into... Grammar, have to ensure that the has a record of this, or you will quote us \ no data found\ exception. 5 4. In the process of storage, alias not same with the field name, otherwise while compiling can pass, but an error in the operation phase 5 5. In the process of storage, null problem about 5 6. Hibernate calls the Oracle stored procedure 6 With Java calls the Oracle stored procedure summarizes six A stored procedure 6, no return value Second, returns a value of the stored procedure (not list) 8 Three, the returned list In the process of sto
Date : 2026-01-03 Size : 25kb User : 郭帅
[Oracle] Cursors-and-exception-handling DL : 0: 熟悉Oracle中游标的类型熟悉游标的属性及使用掌握参数游标的定义及使用掌握使用复合类型接收游标数据掌握预定义异常-Familiar with the cursor in the type of Oracle Familiar with the cursor properties and the use of control parameters of the cursor definition and use of complex data types to receive cursor control Predefined exceptions
Date : 2026-01-03 Size : 178kb User : 顾骨龄