自定义数据类型访问方法

[Novelty]

create type PERSON_TY as object
(Name VARCHAR2(25),
Age NUMBER);

执行成功.

create table EMPLOYEE
(Emp_ID NUMBER,
Person PERSON_TY);

执行成功.

insert into EMPLOYEE values
(1, PERSON_TY('Novel', 23));

执行成功.

select * from EMPLOYEE;

执行成功.

select Emp_ID, Person.Name from EMPLOYEE;

执行失败.
提示:无效的列.

为什么?

[volin]

select emp_id person from employee;

if you want person's name
pls into a variable
then get it

[w_tsinghua]

select Emp_ID, p.Person.name from EMPLOYEE p;
这样就没问题了