SQL> create type addressType as object
2 (Street VARCHAR2(50),
3 City VARCHAR2(25),
4 State CHAR(2),
5 Zip NUMBER);
6 /
SQL> create type personType as object
2 (Name VARCHAR2(25),
3 Address addressType);
4 /
SQL>
SQL> create table emp
2 (cid NUMBER primary key,
3 Name VARCHAR2(25),
4 Street VARCHAR2(50),
5 City VARCHAR2(25),
6 State CHAR(2),
7 Zip NUMBER);
SQL>
SQL> create or replace type empType as object
2 (cid NUMBER,
3 Name VARCHAR2(25),
4 Street VARCHAR2(50),
5 City VARCHAR2(25),
6 State CHAR(2),
7 Zip NUMBER);
8 /
SQL>
SQL> create view empView of empType
2 with object OID (cid) as
3 select cid, Name, Street, City, State, Zip
4 from emp;
SQL>
SQL> drop view empView;
SQL> drop table emp;
SQL>
SQL> drop type personType;
SQL>
SQL> drop type addressType;
SQL>