BEGIN
--create the sub table...
CREATE TYPE tblSubCOURSELIST88 AS TABLE OF VARCHAR2(64);

-- drop main table  
DROP Table RLN_TBLMAINDEPT88;

--create main table
CREATE TABLE RLN_TBLMAINDEPT88 
  (
    DEPT_NAME     VARCHAR2(20),
    DEPT_DIRECTOR VARCHAR2(20),
    DEPT_OFFICE   VARCHAR2(20),
    COURSES       TBLCOURSELIST88
  ) 
    NESTED TABLE COURSES STORE AS RLN_tblSubDEPT88COURSES;

--insert first set into the main table and courses into the sub table
   INSERT INTO RLN_TBLMAINDEPT88
    VALUES('English3', 'Lynn Saunders3', 'Breakstone Hall 23A',
       tblSubCOURSELIST88
           (
             'Expository Writing3' 
            ,'Film and Literature3'
            ,'Modern Science Fiction3'
            ,'Discursive Writing3'
            ,'Modern English Grammar3'
           )
          );

--insert the second set into the main table and courses into the sub table
   INSERT INTO RLN_TBLMAINDEPT88
      VALUES('Music4', 'Clint Ashlock4', 'Yardley Hall 2053',
         tblSubCOURSELIST88
              (
                'Jazz History4'
               ,'Contemporary Jazz4'
               ,'19th Century Jazz4'
               ,'Jazz Fusion4'
               ,'Jazz Improvisational Theory4'
              )
           );

   COMMIT;
    
END;

SQL> CREATE OR REPLACE
  2    TYPE tblSubCOURSELIST88
  3      AS TABLE OF VARCHAR2(64)
  4  /

Type created.

SQL> DROP Table RLN_TBLMAINDEPT88 PURGE
  2  /
DROP Table RLN_TBLMAINDEPT88 PURGE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> CREATE TABLE RLN_TBLMAINDEPT88
  2    (
  3      DEPT_NAME     VARCHAR2(20),
  4      DEPT_DIRECTOR VARCHAR2(20),
  5      DEPT_OFFICE   VARCHAR2(20),
  6      COURSES       tblSubCOURSELIST88
  7    )
  8      NESTED TABLE COURSES STORE AS RLN_tblSubDEPT88COURSES
  9  /

Table created.

SQL>    INSERT INTO RLN_TBLMAINDEPT88
  2      VALUES('English3', 'Lynn Saunders3', 'Breakstone Hall 23A',
  3         tblSubCOURSELIST88
  4             (
  5               'Expository Writing3'
  6              ,'Film and Literature3'
  7              ,'Modern Science Fiction3'
  8              ,'Discursive Writing3'
  9              ,'Modern English Grammar3'
 10             )
 11            )
 12  /

1 row created.

SQL>    INSERT INTO RLN_TBLMAINDEPT88
  2        VALUES('Music4', 'Clint Ashlock4', 'Yardley Hall 2053',
  3           tblSubCOURSELIST88
  4                (
  5                  'Jazz History4'
  6                 ,'Contemporary Jazz4'
  7                 ,'19th Century Jazz4'
  8                 ,'Jazz Fusion4'
  9                 ,'Jazz Improvisational Theory4'
 10                )
 11             )
 12  /

1 row created.

SQL> COMMIT
  2  /

Commit complete.

SQL> SELECT  *
  2    FROM  RLN_TBLMAINDEPT88
  3  /

DEPT_NAME            DEPT_DIRECTOR        DEPT_OFFICE
-------------------- -------------------- --------------------
COURSES
------------------------------------------------------------------------------------------------------------------------------------

English3             Lynn Saunders3       Breakstone Hall 23A
TBLSUBCOURSELIST88('Expository Writing3', 'Film and Literature3', 'Modern Science Fiction3', 'Discursive Writing3', 'Modern English
Grammar3')

Music4               Clint Ashlock4       Yardley Hall 2053
TBLSUBCOURSELIST88('Jazz History4', 'Contemporary Jazz4', '19th Century Jazz4', 'Jazz Fusion4', 'Jazz Improvisational Theory4')


SQL>