CREATE TYPE price_arr AS VARRAY(10) OF NUMBER(12,2);

--
CREATE type share_t as object(
	cname varchar(12),
  	cprice number(6,2),
    exchanges price_arr,
    dividend number(4,2),
    earninngs number(6,2)
)

INSERT INTO shares values('BHP',10.50,excharray('sydney','new york'),1.50,3.20);