oracle type使用

时间：2021-05-31 11:53:24 收藏：0 阅读：11

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;

原文：https://www.cnblogs.com/LoveShare/p/14830198.html