[code="sql"]create or replace type home_type as object(
street varchar2(50),city varchar2(20),
state varchar2(20),zipcode varchar2(10),
owner varchar2(20)
);
create table home of home_type;
insert into home values('上地十街1号','北京','北京','100000','张三');
insert into home values('上地三街2号','北京','北京','100001','里斯');
insert into home values('上地四街3号','北京','北京','100002','李四');
insert into home values('上地五街4号','北京','北京','100003','王五');
insert into home values('上地七街5号','北京','北京','100004','马六');
create table person(
id number(6) primary key,
name varchar2(10),
addr ref home_type
);
insert into person select 1,'zhang san',ref(p) from home p where p.owner='张三';
insert into person select 2,'li si',ref(p) from home p where p.owner='里斯';
insert into person select 3,'kik si',ref(p) from home p where p.owner='李四';
insert into person select 4,'wang wu',ref(p) from home p where p.owner='王五';
insert into person select 5,'ma liu',ref(p) from home p where p.owner='马六';[/code]
[size=large]问:如何查询出person表中的addr的具体信息?[/size]