declare
cursor emptext is
select textid,textname from t_text where textname='ooo';
type t_text_type is table of varchar2(100);
ename_table t_text_type;
begin
open emptext;
fetch emptext bulk collect into ename_table;
for i in 1..ename_table.count loop
dbms_output.put_line(ename_table(i));
end loop;
close emptext;
end;
cursor emptext is
select textid,textname from t_text where textname='ooo';
type t_text_type is table of varchar2(100);
ename_table t_text_type;
begin
open emptext;
fetch emptext bulk collect into ename_table;
for i in 1..ename_table.count loop
dbms_output.put_line(ename_table(i));
end loop;
close emptext;
end;
解决方案 »
- The Connection descriptor used by the client was:127.0.0.1:1521:ORCL
- oracle官方网站下载Oracle Database 10g Client Release 2 (10.2.0.3)是不是对大陆地区关闭了????
- 请问如何在oracle中将字符串000000418000转换为数值型
- 高分相送。如何在pro*C中动态执行存储过程?及存储过程名作为一参数传入,如何实现?谢谢!
- number的问题..
- 如何得到不是数字的数据集
- 利用copy from 将表从一个用户copy到另一个用户出错?
- 这样的情况下,我应该怎么样恢复我的数据库,急,再线等待呢
- 哪位能指点一下,oracle中如何倒入数据?
- Oracle11g创建数据库报错,请高手解决ORA-00119,ORA-00132错误,如图
- 运算符 >: 的问题
- 连接不上数据库
修改下:参考如下:
DECLARE
CURSOR EMPTEXT IS
SELECT empno,ename FROM scott.emp WHERE deptno = 20;
TYPE T_TEXT_TYPE IS TABLE OF VARCHAR2(100);
ENAME_TABLE T_TEXT_TYPE;
x T_TEXT_TYPE;
BEGIN
OPEN EMPTEXT;
FETCH EMPTEXT BULK COLLECT
INTO ENAME_TABLE,x;
FOR I IN 1 .. ENAME_TABLE.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(ENAME_TABLE(I));
END LOOP;
CLOSE EMPTEXT;
END;
/