CREATE Or Replace TYPE AddressType AS OBJECT (
  street VARCHAR2(15),
  city   VARCHAR2(15),
  state  CHAR(2),
  zip    VARCHAR2(5)
)

CREATE Or Replace TYPE PersonType AS OBJECT (
  id         NUMBER,
  first_name VARCHAR2(10),
  last_name  VARCHAR2(10),
  dob        DATE,
  phone      VARCHAR2(12),
  address    AddressType
) NOT FINAL;

CREATE Or replace TYPE business_PersonType UNDER PersonType (
  title   VARCHAR2(20),
  company VARCHAR2(20)
)

CREATE TABLE object_business_customers OF business_PersonType


INSERT INTO object_business_customers VALUES (
  business_PersonType(1, 'John', 'Brown', '01-FEB-1933', '800-555-3333',
    AddressType('2 Ave', 'town', 'MA', '12345'),'Manager', 'XYZ Corp')
);


SELECT *
FROM object_business_customers;

 ID FIRST_NAME  LAST_NAME DOB       PHONE        ADDRESS(STREET, CITY, STATE, ZIP)           TITLE    COMPANY
-------------------- --------------------
  1 John        Brown     01-FEB-33 800-555-3333 ADDRESSTYPE('2 Ave', 'town', 'MA', '12345') Manager  XYZ Corp