SQL>
SQL> create or replace type employeeType is object (
2 empNo NUMBER,
3 deptNo NUMBER
4 )
5 /
Type created.
SQL>
SQL> desc employeeType
Name Null? Type
-----------------------------
EMPNO NUMBER
DEPTNO NUMBER
SQL> /
Type created.
SQL>
SQL> alter type employeeType
2 drop attribute empno
3 /
Type altered.
SQL>
SQL> drop type employeeType
2 /
Type dropped.
SQL>