17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> create or replace function f_test return dbms_sql.Varchar2_Table as
2 v_ename_table dbms_sql.Varchar2_Table;
3 begin
4 select ename bulk collect into v_ename_table from emp;
5 return v_ename_table;
6 end;
7 /
Function created
SQL>
SQL> set serveroutput on;
SQL> declare
2 v_ename_table dbms_sql.Varchar2_Table;
3 begin
4 v_ename_table := f_test;
5 for i in 1..v_ename_table.count loop
6 dbms_output.put_line(v_ename_table(i));
7 end loop;
8 end;
9 /
SMIT H1
ALLE N
WARD
JONE S
MART IN
BLAK E
CLAR K
SCOT T
KING
TURN ER
ADAM S
JAME S
FORD
MILL ER
PL/SQL procedure successfully completed