All pastes #502170 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-05-22 11:51 UTC
rendered paste body
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)
);
/