CREATE OR REPLACE TYPE HoldingType AS OBJECT
(
  Customer  REF CustomerType, --SCOPE IS CustomerTable
  HoldingSecurity REF SecurityType, --SCOPE IS SecurityTable
  SharesHeld  NUMBER(5)
)
  FINAL
  INSTANTIABLE;
/
CREATE TABLE HoldingTable OF HoldingType
(
  CONSTRAINT CUSTOMER_PK PRIMARY KEY (SELF.HoldingSecurity.Symbol, SELF.Customer.CustomerNo)
);
/