SQL>
SQL> --CREATE [OR REPLACE] TYPE AS TABLE OF (object schema)
SQL> --/
SQL> --CREATE TABLE
SQL> -- (attribute attribute type, ....,
SQL> -- attribute attribute type,
SQL> -- nested item object table schema);
SQL> -- NESTED TABLE nested item STORE AS storage table schema;
SQL>
SQL> --CREATE TABLE
SQL> -- (attribute attribute type, ....,
SQL> -- outer nested item object table schema);
SQL> -- NESTED TABLE
SQL> -- STORE AS
SQL> -- (NESTED TABLE
SQL> -- STORE AS );
SQL>
SQL> --Example:
SQL>
SQL> CREATE OR REPLACE TYPE personType AS OBJECT
2 (person_id VARCHAR2(10),
3 person_name VARCHAR2(30))
4 /
Type created.
SQL>
SQL>
SQL> CREATE OR REPLACE TYPE Person_Table AS TABLE OF personType
2 /
Type created.
SQL>
SQL>
SQL>
SQL>
SQL> CREATE TABLE Course
2 (course_id VARCHAR2(10),
3 course_name VARCHAR2(20),
4 Programmer Person_Table)
5 NESTED TABLE Programmer STORE AS Person_tab;
Table created.
SQL>
SQL>
SQL>
SQL>
SQL> drop table course;
Table dropped.
SQL>
SQL>
SQL>