oracle pl/sql Nested Table

看了一下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;