In the object table, where each attribute becomes a column.
Each row in the object table contains a unique object identifier.
SQL> create or replace type employeeType is object (
2 empNo NUMBER,
3 eName VARCHAR2(10),
4 job VARCHAR2(9),
5 mgr NUMBER,
6 hireDate DATE,
7 sal NUMBER,
8 comm NUMBER,
9 deptNo NUMBER
10 )
11 /
Type created.
SQL>
SQL> create table t_emp of employeeType;
Table created.
SQL>
SQL> drop table t_emp;
Table dropped.
SQL> drop type employeeType;
Type dropped.
SQL>