Example: Schema Description used in examples of OraCollection

CREATE TYPE ENAMELIST AS VARRAY(20) OF VARCHAR2(30);

CREATE TABLE department (

dept_id NUMBER(2),

name VARCHAR2(15),

ENAMES ENAMELIST);

DROP TYPE COURSE;

CREATE TYPE Course AS OBJECT (

course_no NUMBER(4),

title VARCHAR2(35),

credits NUMBER(1));

CREATE TYPE CourseList AS TABLE OF Course;

CREATE TABLE division (

name VARCHAR2(20),

director VARCHAR2(20),

office VARCHAR2(20),

courses CourseList)

NESTED TABLE courses STORE AS courses_tab;