看了一下 PL/SQL User's Guide and Reference,发现nested table真的很不错
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm
CREATE TYPE CourseList AS TABLE OF VARCHAR2(10) -- define type / CREATE TYPE Student AS OBJECT ( -- create object id_num INTEGER(4), name VARCHAR2(25), address VARCHAR2(35), status CHAR(2), courses CourseList) -- declare nested table as attribute /
定义了课程列表的嵌套表,并是使用其构造方法插入多组数据
DECLARE TYPE CourseList IS TABLE OF VARCHAR2(16); my_courses CourseList; BEGIN my_courses := CourseList('Econ 2010', 'Acct 3401', 'Mgmt 3100'); END;