A Simple Example of Weak Ref Cursor

来源：互联网发布：计算机二级vb考试题型编辑：程序博客网时间：2024/05/22 11:48

DECLARE l_sql VARCHAR2(2000) := 'select deptno,loc from scott.dept'; l_where VARCHAR2(200); TYPE dept_curtype IS REF CURSOR; dept_cur dept_curtype; TYPE dept_rec IS RECORD( deptno VARCHAR2(200) --attention the record element order ,loc VARCHAR2(200)); TYPE dept_tbl IS TABLE OF dept_rec; l_dept_tbl dept_tbl;BEGIN l_where := ' where deptno = :deptno'; l_sql := l_sql || l_where; OPEN dept_cur FOR l_sql USING 40 --USING is not necessary ; FETCH dept_cur BULK COLLECT INTO l_dept_tbl; CLOSE dept_cur; dbms_output.put_line('l_str_tbl.COUNT = ' || l_dept_tbl.COUNT); <<l_dept_tbl_loop>> FOR i IN 1 .. l_dept_tbl.COUNT LOOP dbms_output.put_line('l_str_tbl(' || i || ').deptno = ' || l_dept_tbl(i).deptno || ', l_str_tbl(' || i || ').loc = ' || l_dept_tbl(i).loc); END LOOP l_dept_tbl_loop;END;

A Simple Example of Weak Ref Cursor
a simple example of Ado.net
A simple example of PHP closure
A simple example of exceptional handing in function
WPF A simple example of implementing ICommand Binding
A Simple Example of Dynamic Programming using perl scripts
a simple ajax example
A simple wxPython example
A simple DirectShow example
A simple GetOpenFileName example
A simple makefile example
A simple JNI example
a simple example rabbitMQ
one simple example of yield
Using of REF CURSOR in PL/SQL
coding with a simple example
A Simple Quartz/Spring Example
A Simple Session Establishment Example
基于sim RBF网络的非线性滤波
把表里的数据导出生成脚本
用VBA判断指定的文件夹或文件是否存在
Web页面实时刷新技术探讨
Struts2 ：could not be resolved as a collection/array/map/enumeration/iterator type
A Simple Example of Weak Ref Cursor
Windows 7下安装Rational Rose 2003
div弹出层
Linux下生成动态库和静态库
WINCE6.0 RIL [二] RIL移植
Are Green Concerts Green?
String data type： printf & cout output differently
PHP超级配置模块--PHP4,PHP5,module,cgi任你玩转--应用于Apache
Android学习11Android上的网络编程