oracle动态游标
来源:互联网 发布:nginx代理静态文件夹 编辑:程序博客网 时间:2024/05/16 07:17
/*
动态游标使用:
1:在包规范中声明自定义游标类型
type type_cursor is ref cursor;
*/
create or replace package pkg_query_all
is
type type_ref_cursor is ref cursor;
procedure queryall(p_tname nvarchar2);
procedure queryall(p_tname nvarchar2, o_list out type_ref_cursor);
end pkg_query_all;
---------------------------------
create or replace package body pkg_query_all
is
procedure queryall(p_tname nvarchar2)
is
teacher_list pkg_query_all.type_ref_cursor;
item teacher%rowtype;
v_sql varchar2(1000);
begin
v_sql := 'select * from teacher where 1=1 ';
if p_tname is not null then
v_sql := v_sql || ' and tname = '''||p_tname||'''';
end if;
open teacher_list for v_sql;
loop
fetch teacher_list into item;
exit when teacher_list%notfound;
dbms_output.put_line(item.tno||'-'||item.tname);
end loop;
close teacher_list;
end queryall;
procedure queryall(p_tname nvarchar2, o_list out type_ref_cursor)
is
teacher_list type_ref_cursor;
v_sql varchar2(1000);
begin
v_sql := 'select * from teacher where 1=1 ';
if p_tname is not null then
v_sql := v_sql || ' and tname = '''||p_tname||'''';
end if;
open teacher_list for v_sql;
o_list := teacher_list;
end queryall;
end pkg_query_all;
---------------------------------
--测试
select * from teacher;
begin
pkg_query_all.queryall('郭嘉');
end;
declare
teacher_list pkg_query_all.type_ref_cursor;
item teacher%rowtype;
begin
pkg_query_all.queryall('曹操', teacher_list); --参数如果为空,使用null
loop
fetch teacher_list into item;
exit when teacher_list%notfound;
dbms_output.put_line(item.tno||'-'||item.tname);
end loop;
end;
动态游标使用:
1:在包规范中声明自定义游标类型
type type_cursor is ref cursor;
*/
create or replace package pkg_query_all
is
type type_ref_cursor is ref cursor;
procedure queryall(p_tname nvarchar2);
procedure queryall(p_tname nvarchar2, o_list out type_ref_cursor);
end pkg_query_all;
---------------------------------
create or replace package body pkg_query_all
is
procedure queryall(p_tname nvarchar2)
is
teacher_list pkg_query_all.type_ref_cursor;
item teacher%rowtype;
v_sql varchar2(1000);
begin
v_sql := 'select * from teacher where 1=1 ';
if p_tname is not null then
v_sql := v_sql || ' and tname = '''||p_tname||'''';
end if;
open teacher_list for v_sql;
loop
fetch teacher_list into item;
exit when teacher_list%notfound;
dbms_output.put_line(item.tno||'-'||item.tname);
end loop;
close teacher_list;
end queryall;
procedure queryall(p_tname nvarchar2, o_list out type_ref_cursor)
is
teacher_list type_ref_cursor;
v_sql varchar2(1000);
begin
v_sql := 'select * from teacher where 1=1 ';
if p_tname is not null then
v_sql := v_sql || ' and tname = '''||p_tname||'''';
end if;
open teacher_list for v_sql;
o_list := teacher_list;
end queryall;
end pkg_query_all;
---------------------------------
--测试
select * from teacher;
begin
pkg_query_all.queryall('郭嘉');
end;
declare
teacher_list pkg_query_all.type_ref_cursor;
item teacher%rowtype;
begin
pkg_query_all.queryall('曹操', teacher_list); --参数如果为空,使用null
loop
fetch teacher_list into item;
exit when teacher_list%notfound;
dbms_output.put_line(item.tno||'-'||item.tname);
end loop;
end;
0 0
- 【oracle游标三】动态游标
- Oracle动态游标入门
- oracle 动态游标
- oracle动态游标实例
- oracle动态游标
- oracle动态游标
- Oracle动态游标
- oracle动态游标
- Oracle REF动态游标
- oracle 游标(显示游标,隐式游标,动态游标)
- Oracle游标(三)REF动态游标
- Oracle动态游标入门一
- oracle动态游标入门二
- Java调用Oracle动态游标
- Oracle使用REF 动态游标
- Java调用Oracle动态游标
- Oracle 动态游标的用法
- oracle之动态sql、游标
- hive数据仓库图
- A+B高精度问题
- hdu 5020 Revenge of Collinearity(STL,组合,思路)
- 10001---使用 Filter 作为控制器的 MVC
- 矩阵范数
- oracle动态游标
- JQuery中位置选择器:nth-child(N)与:eq(N)的差别
- 10002---Struts2 的 Hello World
- jQuery validate 根据上下文条件动态给字段添加或删除验证选项?
- BootstrapTest_3(基础排板样式)
- 终于在理解虚拟地址与物理地址后写好了第一个linux驱动——led驱动
- Dagger2 使用详解
- 自定义C++类注册到Lua环境中遇到的问题
- Button的点击事件(显隐)