Oracle/PLSQL: OPEN Statement
来源:互联网 发布:小明看看永久域名20 编辑:程序博客网 时间:2024/06/05 05:47
Oracle/PLSQL: OPEN Statement
Once you've declared your cursor, the next step is to open the cursor.
译:在你定义好一个游标后,下一步就是打开该游标。
The basic syntax to OPEN the cursor is:
OPEN cursor_name;
For example, you could open a cursor called c1 with the following command:
译:例如,你可以使用如下命令打开一个名为c1有游标:
OPEN c1;
Below is a function that demonstrates how to use the OPEN statement:
译:下面是一个演示如何例用OPEN的方法:
CREATE OR REPLACE Function FindCourse
( name_in IN varchar2 )
RETURN number
IS
cnumber number;
( name_in IN varchar2 )
RETURN number
IS
cnumber number;
CURSOR c1
IS
SELECT course_number
from courses_tbl
where course_name = name_in;
BEGIN
IS
SELECT course_number
from courses_tbl
where course_name = name_in;
BEGIN
open c1;
fetch c1 into cnumber;
if c1%notfound then
cnumber := 9999;
end if;
close c1;
fetch c1 into cnumber;
if c1%notfound then
cnumber := 9999;
end if;
close c1;
RETURN cnumber;
END;
- Oracle/PLSQL: OPEN Statement
- Oracle/PLSQL: Case Statement
- Oracle/PLSQL: Exit Statement
- Oracle/PLSQL: FETCH Statement
- Oracle / PLSQL: ALTER TABLE Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- PLSQL:Exit Statement
- Oracle PLSQL之cursor取得是open时的数据
- oracle plsql
- oracle plsql
- oracle plsql
- oracle--PLSQL
- oracle plsql
- Oracle sql statement tuning
- Oracle statement 笔记
- INITIAL-D-SECOND STAGE - 第2话 『LANEVO军团 秋名出击』
- Project Server 2003安装序
- Oracle/PLSQL: FOR Loop
- INITIAL-D-SECOND STAGE - 第3话 『败北的预感』
- 软件项目质量管理经验谈
- Oracle/PLSQL: OPEN Statement
- 【3】性能观察:Trove集合类
- SQL Server 查询分析器快捷键集合
- INITIAL-D-SECOND STAGE - 第4话 『燃烧不了的胜利』
- Windows 窗体的.Net 框架绘图技术
- 認識系統服務 daemons
- 【4】Java理论和实践:了解泛型
- 颜色代码大全
- How to freeze a dynamic aspx page into a static html page (on the server).