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;