17,086
社区成员
发帖
与我相关
我的任务
分享
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as oracle@ORALAB
SQL> set serverout on
SQL>
SQL>
SQL> declare
2 -- 先定义一个 type ,这个是必须的
3 type type_list is table of varchar(30) index by pls_integer ;
4 -- 再定义一个变量,就是数组变量
5 t_list type_list ;
6 begin
7 -- 写一批数据过来,bulk collect into 这个关键字
8 select object_name bulk collect into t_list from user_objects ;
9
10 -- 直接循环这个数组就可以了
11 for i in 1..t_list.count()
12 loop
13 dbms_output.put_line(t_list(i));
14 end loop ;
15 end ;
16 /
A
SYS_C0010834
YYYY
SYS_C0010832
XX
USE_BIGGEST2
USE_BIGGEST1
LIMITS_PKG
FN_SUM
TAB_NUMBER
P1
P1
SYS_C0010849
TICKET_INFO
TICKET_INFO
TICKET_INFO
TICKET_INFO
TICKET_INFO
TICKET_INFO
CT_T_INVOICE
CT_T_CONTRACTITEM
CT_T_SHIPMENTTEMP
CT_T_SHIPMENT
EX01_PHONE_TB
EX01_PERSON_TB
PL/SQL procedure successfully completed
SQL>