Oracle动态游标的使用
declare
sqlstr varchar2(500);
type vv is ref cursor;
ev vv;
v varchar2(50);
begin
sqlstr:='select username from ysnk_employees';
open ev for sqlstr;
fetch ev into v;
dbms_output.put_line(v);
end;
==========================================================
游标变量在定义是不指定固定的SQL语句,在Open时才指定SQL语句
sqlstr varchar2(500);
type vv is ref cursor;
ev vv;
v varchar2(50);
begin
sqlstr:='select username from ysnk_employees';
open ev for sqlstr;
fetch ev into v;
dbms_output.put_line(v);
end;
==========================================================
游标变量在定义是不指定固定的SQL语句,在Open时才指定SQL语句
posted on 2012-01-16 16:09 kudosharry 阅读(563) 评论(0) 编辑 收藏 举报