-- Created on 2007-10-23 by TIEBING
declare
type ename_table_type is table of emp.ename%type index by binary_integer;
ename_table ename_table_type;
sql_stat varchar2(100);
begin
-- Test statements here
sql_stat :='select ename from emp where deptno= :dno';
execute immediate sql_stat
bulk collect into ename_table using &dno;
for i in l..ename_table.count loop
dbms_output.put_line(ename_table(i));
end loop;
end;
/
declare
type ename_table_type is table of emp.ename%type index by binary_integer;
ename_table ename_table_type;
sql_stat varchar2(100);
begin
-- Test statements here
sql_stat :='select ename from emp where deptno= :dno';
execute immediate sql_stat
bulk collect into ename_table using &dno;
for i in l..ename_table.count loop
dbms_output.put_line(ename_table(i));
end loop;
end;
/
谢谢哈
type ename_table_type is table of emp.ename%type index by binary_integer;
ename_table ename_table_type;
sql_stat varchar2(100);
begin
-- Test statements here
sql_stat := 'select ename from emp where deptno= :dno ';
execute immediate sql_stat
bulk collect into ename_table using '&dno';
for i in 1..ename_table.count loop
dbms_output.put_line(ename_table(i));
end loop;
end;
/