VARRAYS
Thu Sep 23 2021 08:07:57 GMT+0000 (Coordinated Universal Time)
Saved by
@kaveen
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);
content_copyCOPY
Comments