CREATE OR REPLACE TYPE scott.o_emp_type AS OBJECT (
   empno   NUMBER,
   ename   VARCHAR2 (10),
   job     VARCHAR2 (9)
);

CREATE OR REPLACE TYPE scott.t_emp_type AS TABLE OF o_emp_type;


CREATE OR REPLACE TYPE scott.o_dept_type AS OBJECT (
   deptno        NUMBER,
   dname         VARCHAR2 (14),
   loc           VARCHAR2 (13),
   tt_emp_type   t_emp_type
);

CREATE OR REPLACE TYPE scott.t_dept_type AS TABLE OF o_dept_type;