SQL>
SQL>
SQL> CREATE OR REPLACE TYPE officeType AS OBJECT
2 (office_id VARCHAR2(10),
3 building_name VARCHAR2(20))
4 /
Type created.
SQL>
SQL> CREATE OR REPLACE TYPE personType AS OBJECT
2 (person_id VARCHAR2(10),
3 person_name VARCHAR2(30),
4 person_office REF officeType)
5 /
Type created.
SQL>
SQL> CREATE TABLE Office OF officeType
2 (office_id NOT NULL,
3 PRIMARY KEY (office_id));
Table created.
SQL>
SQL> CREATE TABLE Programmer OF personType
2 (person_id NOT NULL,
3 PRIMARY KEY (person_id));
Table created.
SQL>
SQL> drop type officeType force;
Type dropped.
SQL> drop type personType force;
Type dropped.
SQL> drop table Office;
Table dropped.
SQL> drop table Programmer;
Table dropped.