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;
Subscribe to:
Post Comments (Atom)
0 Responses so far.
Post a Comment