給你一個簡單的例子

SQL code?

SQL> declare

2 type t_list is table of date index by pls_integer ;

3 list t_list ;

4 begin

5 list(1) := to_date("2015-10-03","YYYY-MM-DD") ;

6 list(2) := to_date("2015-10-04","YYYY-MM-DD") ;

7 list(3) := to_date("2015-10-05","YYYY-MM-DD") ;

8 for i in 1.. list.count

9 loop

10 dbms_output.put_line(list(i)) ;

11 end loop ;

12 end ;

13 /

03-10月-15

04-10月-15

05-10月-15

PL/SQL procedure successfully completed

SQL>