Oracle显式光标应用举例及缺陷分析

Analyzing the Limitation of an Application of Explicit Cursor in Oracle

显式光标又称为用户自定义光标,通过用户对光标自行定义来解决PL/SQL程序中查询返回多行的问题。该文主要介绍作者在Oracle显式光标应用的教学过程中的举例,讨论了相关例子的缺陷并提出解决的方法。

An explicit cursor names the unnamed work area in which the database stores processing information when it executes a multiple-row query.This paper analyses the limitation of an application of explicit cursor in oracle.And the author’s sugges tions are also mentioned in this paper.