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;
解决方案 »
- 请高手帮助sql语句
- oracle Date类型Insert 一个类似于0000/00/00的非法日期
- Linux下用OCI远程访问oracle,要连接的远端数据库参数在函数OCIServerAttach()中正确的格式是什么?
- 求一小小的SQL语句
- 请问:ORACLE 中授什么权限 ,可用select * from user_col_comments ?
- long 类型的大小问题?
- 如何配置Oracle 中net?请高手给指点!!
- 问一个PB连oracle数据库的问题
- 大家好,请帮我看看---给你加星星!
- oracle8.1.7(中文)中DATE类型的问题!急!
- 关于一个 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;
/