VARRAY Simple Tutorial (Oracle)

CREATE TYPE prices AS VARRY(10) OF NUMBER (5,2);

CREATE TABLE pricelist(
pno integer,
prices prices)
/

insert into pricelist values(1,prices(10.20,23.30,33.50));

select * from pricelist;

Labels:

0 Responses so far.