CREATE OR REPLACE TYPE DepartmentType AS OBJECT (
   dno          NUMBER,
   name         VARCHAR2(20),
   budget       NUMBER
);
/


CREATE OR REPLACE TYPE PersonType AS OBJECT (
   id           NUMBER,
   name         VARCHAR2(20),
   birthdate    DATE
)NOT INSTANTIABLE NOT FINAL;
/


CREATE OR REPLACE TYPE EmployeeType UNDER PersonType (
   worksIn      REF     DepartmentType,
   dateHired    DATE,
   status       NUMBER
);
/

CREATE TABLE DepartmentTab OF DepartmentType
(PRIMARY KEY (dno))
 OBJECT ID PRIMARY KEY
/

CREATE TABLE PersonTab OF PersonType
(PRIMARY KEY (id))
OBJECT ID PRIMARY KEY
/

LOAD DATA
INFILE './deps.cls'
INTO TABLE departmentTab
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

          ( dno         INTEGER EXTERNAL(3),
            name        CHAR(20),
            budget      INTEGER EXTERNAL(12))

LOAD DATA
        INFILE './emps.cls'
        INTO TABLE personTab
        TREAT AS EmployeeType
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

          ( id          INTEGER EXTERNAL(8),
            name        CHAR(20),
            birthdate   "TO_DATE(:birthdate, 'MM/DD/YYYY')",
            worksin     REF (CONSTANT 'DEPARTMENTTAB', dno),
            dno         FILLER INTEGER EXTERNAL(5),
            datehired   "TO_DATE(:datehired, 'MM/DD/YYYY')",
            status      INTEGER EXTERNAL(2))

and sample data:
deps.cls:
1,"Biology",100000,
2,"German",200000,

emps.cls:
1,"Scott Jobs","8/12/1959",1,"11/10/1989", 4,
2,"Samir Barak","3/1/1963",1,"8/02/1985",6,