CREATE OR REPLACE PACKAGE BODY P_BODY
AS
CURSOR lvMy IS SELECT * FROM TEST;
解决方案 »
- oracle 11g dblink 连接只能访问一条数据
- 中秋散分!!!!!!!!____顺便问一问题,rowset中插不了行???
- 查询语句同时显示明细与合计
- 紧急求助。。。,Long Raw类型 转换问题
- 在sql*plus里执行select * from job_work 怎么会出错?急!!!
- Oracle 8i 如何导出建库脚本(不用工具)
- Oracle 9.2在RedHat9.0上安装的错误!请大侠们们出招!
- oracle9i?
- 高分相送,用asp连接oracle9i的问题,在线等待!
- 多条sql查询一个表的多个结果合并到一个表中,视图sql应该怎么写?
- 江湖救急,在线等候!!
- 排序问题,各位大侠帮忙!
open cursor_name
fetch cursor into file
.....
loop
close cursor
as
type mycursor is ref cursor;
end;
/
create procedure pro(p_rc out test_age.mycursor)
as
begin
open p_rc for select * from table;
end;
/
cursor cursor_name is select * from table;
open cursor_name;
fetch cursor into file;
while cursor_name%FOUND then
.....;
fetch cursor into file;
loop;
close cursor;
set serveroutput ondeclare
vchcontent varchar2(500);
begin
declare
cursor cursor_name is select * from tu_smsvc_sub_mes;
open cursor_name;
fetch cursor into file;
while cursor_name%FOUND then
dbms_output.put_line('ppp');
fetch cursor into file;
loop;
close cursor;
end;
但运行没有通过请问应该怎么改??
我想写一个游标,通过游标把两条记录保存到一个变量里。以前用sql sever就写过,不过用orcale才学了几天,搞不出来!
vchcontent varchar2(500);
file tu_smsvc_sub_mes%ROWTYPE;
begin
declare
cursor cursor_name is select * from tu_smsvc_sub_mes;
open cursor_name;
fetch cursor into file;
while cursor_name%FOUND then
dbms_output.put_line('ppp');
fetch cursor into file;
loop;
close cursor;
end;
vchcontent varchar2(500);
cursor cursor_name is select * from tu_smsvc_sub_mes;
begin
open cursor_name;
fetch cursor_name into file;
while cursor_name%FOUND then
dbms_output.put_line('ppp');
fetch cursor into file;
end loop;
close cursor;
end;
/
set serveroutput on;
declare
v_salary varchar2(1500):='';
content varchar2(1500):='';
inti number:=0;
cursor mycursor is select content from tu_smsvc_sub_mes where code='8300';
begin
open mycursor;
loop
fetch mycursor into v_salary;
exit when mycursor%notfound;
begin
inti:=1+inti;
content:=v_salary||content;
end;
end loop;
dbms_output.put_line(content);
close mycursor;
end;
我还想问一下处了exit when mycursor%notfound还有什么办法控制游标的指针?要是我取游标的第2条记录呢??