1.创建一个varray
create type articl_type as
object(
title varchar2(30),pubdate date
);
create type article_array is
varray(20) of article_type;
create table author(
id number(6),name varchar2(10),article article_array
) --将varray数据放在数据表列中
create type articl_type as
object(
title varchar2(30),pubdate date
);
create type article_array is
varray(20) of article_type;
create table author(
id number(6),name varchar2(10),article article_array
) --将varray数据放在数据表列中