oracle期末考试简答题

pl/sql development 学习pl/sql的好资料-pl/sql development learning pl/sql good information

为了得到最大的性能，一般数据库都有并发机制，不过带来的问题就是数据访问的冲突。为了解决这个问题，大多数数据库用的方法就是数据的锁定.-In order to get the maximum performance, a general mechanism for the database have complicated, but the problem is caused by data access conflicts. To solve this problem, the majority of the database is used to lock data.

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 (

去年做的实验，，不知道对大家有没有用。

This Online Student Management System which used JDeveloper and Oracle together.-This is Online Student Management System which used JDeveloper and Oracle together.

用测试OLE DB提供者的一个程序。能够测试出OEL DB提供者到底实现了哪些接口？很灵的。-test with OLE DB provider of a procedure. To test the OEL DB providers to achieve what in the end interface? Very souls.

通过ADO访问数据库的方法的封装类的实现文件,以某数据可为例子访问-access to the database through ADO methods of achieving such Packaging document to a particular data can be visited as an example

当需要从一个数据库中取出某些大量数据导入到另一个数据库中时，由其还需要隔一段时间取一次，就会非常麻烦，所以我整理了这些代码，可以自己定时从一个数据库中取数据传到另一个数据库中，省时省力很方便。

关于ORACLE数据库比较基础的知识，针对初学者学习ORACLE具有深入了解。-ORACLE database on the basis of comparison of knowledge, for beginners to learn with a deeper understanding of ORACLE.

手动kill掉inactive session的一个存储过程。-manually kill swap inactive session of a stored procedure.