CREATE OR REPLACE TYPE birthdate_type AS OBJECT(
year NUMBER(4),
month NUMBER(1)
);
CREATE OR REPLACE TYPE birthdate_tbl_type AS TABLE OF birthdate_type;
create TABLE person(
name varchar2(50),
birthdate birthdate_tbl_type
)
NESTED TABLE birthdate STORE AS birthdate_nest;
insert into person
select ‘Alan‘, CAST(MULTISET
(SELECT 1982,1
FROM dual) AS birthdate_tbl_type)
from dual;