oracle实现增删改查功能

此代码为利用PL/SQL开发数据库存储过程的典型示例，此为第2部分，希望大家可以通过该代码清楚如何利用SQL语句实现复杂的业务逻辑。-this code for the use of PL/SQL stored procedures development of the database of typical examples of this Part 2, We can hope that the adoption of the code clearly how to use SQL to achieve complex business logic.

真受不了，还要解释，就是一些cobol的东东啦，看看就会晓得了嘛-really hollered, but also explained that some of the COBOL-- Wanton, will look at the know! !

说明：  使用occi远程连接oracle数据库,固定模式.代码简洁明了,适合初学者参考(use of remote connectivity oracle database, fixed patterns. Code concise, for beginners reference)

说明：  ORACLE安装所需补丁包，解压后使用。。。。。(ORACLE Installation Required Patch Pack, After Decompression, Use)

一个非常实用的Oracle ADF案例，项目全周期资金计划

介绍ORACLE11g的sql开发指南，全英文版-Introduction ORACLE11g the sql Developer" s Guide, full English

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 (

2、 编写一个过程模拟到读书室刷卡借书。要求有一个IN参数和一个OUT参数。IN参数用于接受传递过来的借书证条码，然后在表中检索有无读者，如有则将该读者的名称赋给OUT参数。如没有则提示“没有找到该读者信息”。

Lyrics Editing System Developed in NetBeans 6.5

这是一个基于jbpm4.3的小项目，oracle10g数据库，一个完整的请假流程(This is a small project jbpm4.3' s, oracle10g database, a complete flow of leave)