CREATE TYPE employee_type AS OBJECT
  (name     VARCHAR2(30),
   age      NUMBER(3),
   emp_id   NUMBER(5)) not final;

CREATE TYPE hourly_emp_type UNDER employee_type
  (wage     NUMBER(3));

CREATE TYPE salary_emp_type UNDER employee_type
  (salary   NUMBER(6));

CREATE TABLE employeeTab of employee_type;

LOAD DATA

   INFILE 'hour.dat'
   INTO TABLE employeeTab
   TREAT AS hourly_emp_type
   FIELDS TERMINATED BY ','
     (name     CHAR(30),
      age      INTEGER EXTERNAL(3),
      emp_id   INTEGER EXTERNAL(5),
      wage     INTEGER EXTERNAL(3))