create type address_type as object
( city varchar2(15),
zip varchar2(5));
/
create type bbb as table of address_type;
/
create table ccc(
id integer primary key,
name varchar2(15),
address bbb)
nested table
address
store as
nested_addresses;
添加
insert into ccc values( 1, 'hi',bbb( address_type ('bki' , 't'),
address_type('bhy' , 'y')
)
);