open cur for
select * from a where rowid <= 50
用游标
select * from a where rowid <= 50
用游标
解决方案 »
- oracle语句查询
- 疑难杂症: ORA-01438: value larger than specified precision allowed for this column
- ORACLE中哪个客户执行的SQL有记录吗
- unable to extend segment
- ORA-06550: 第 1 行, 第 13 列: !!什么错误,谢谢!
- 请问关于sql与oracle的数据类型的区别!
- 很急得问题,数据库出现“死锁”!
- oracle的proceduce能不能访问其他数据库?
- 最后一问,请大家帮忙看看,已经用了300了!
- ora-01034:oracle not available,怎么回事呀?
- 初学oracle的困惑???
- 简单问题
create or replace package pkg_test
as
type myCursor is ref cursor;
function get(p_id number) return myCursor;
end pkg_test;
--包体
create or replace package body pkg_test
as
--******************************************************************
--输入ID 返回记录集的函数
function get(p_id number) return myCursor is
rc myCursor;
strsql varchar2(200);
begin
if p_id=0 then
open rc for select a.user_name from fnd_user a ;
else
strsql:='select a.user_name from fnd_user a where a.user_id=:p_id';
open rc for strsql using p_id;
end if;
return rc;
end get;
end pkg_test;--调用
set serverout on
declare
w_rc pkg_test.myCursor;
w_name varchar2(100);
begin
w_rc:=pkg_test.get(0);
loop
fetch w_rc into w_name;
exit when w_rc%notfound;
dbms_output.put_line(w_name);
end loop;
end;
/