oracle-type

一、as table of

     例子1：

CREATE OR REPLACE TYPE "TYPE_NAME"   as table of varchar2(25);  --定义

declare
  t_list type_name;
begin
  select distinct (rs.id) bulk collect
    into t_list
    from t_cust_customers rs;
  FOR cust_record IN (select vtable.column_value custid
                        from table(t_list) vtable) LOOP
    dbms_output.put_line(cust_record.custid);
  END LOOP;
end;