Consider the following types:
CREATE TYPE employee_type AS OBJECT
emp_id NUMBER(5)) not final;
CREATE TYPE hourly_emp_type UNDER employee_type
CREATE TYPE salary_emp_type UNDER employee_type
CREATE TABLE employeeTab of employee_type;
If I have data for hourly employees in hour.dat and for salary employees in salary.dat, how would I load both of them into employeeTab??
This is the control file for loading data for the hourly emps:
INTO TABLE employeeTab
TREAT AS hourly_emp_type
FIELDS TERMINATED BY ','
age INTEGER EXTERNAL(3),
emp_id INTEGER EXTERNAL(5),
wage INTEGER EXTERNAL(3))
Is it possible? How would I have to modify the control file? Thanks,