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);