PLSQL collection 示例 之 Nested Tables

CREATE TABLE Person
(Id int,
Name varchar(255));

BEGIN
FOR i IN 1..4 LOOP
insert into person values(i,’abc’||i);
END LOOP;
commit;
END;

DECLARE
CURSOR cursor_person is SELECT name FROM person;
TYPE person_list IS TABLE of person.name%type;
name_list person_list := person_list();
counter integer :=0;
BEGIN
FOR n IN cursor_person LOOP
counter := counter +1;
name_list.extend;
name_list(counter) := n.name;
dbms_output.put_line(‘Person No.(‘||counter||’):’||name_list(counter));
END LOOP;
END;