declare
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;
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;
解决方案 »
- ora-00942 表或视图不存在 奇怪问题
- 菜鸟 求助~!oracle
- 一个关于“超出打开游标最大数”的错误,请高手帮忙
- java连接oracle问题
- 帮忙看下这条SQL怎么写?急!!
- 存储过程中定义包体(package body)时提示这个错误
- 在线待解决一个关于imp的问题!
- 关于 oracle Enterprise Manager Console 的问题,恳请各位帮忙
- 急,SQL问题,不会写了!!!
- ***如何通过delphi进行oracle的备份和恢复操作?另加200分!!!***
- 关于一个 EXISTS的查询判断语句的则么写,求急~~~~~~~~~~~~~
- 请问:如何在java里调用oracle的存储过程;谢谢赐教!!!
declare
v_a a%rowtype;
v_rc test_age.mycursor;
begin
open v_rc;
loop
fetch v_rc into v_a;
exit when v_rc%notfound;
dbms_output.put_line(v_a.col_name);
end loop;
close v_rc;
end;
/