create or replace type addr_type as OBJECT(
street nvarchar2(30),
city nvarchar2(6),
state nvarchar2(10),
zip varchar2(6),
country nvarchar2(16)
);create type addr_type_tbl is table of addr_type;create table cust1(id varchar2(20),name nvarchar2(20),address addr_type_tbl)nested table address store as address;insert into cust1 values('785411','函数',addr_type_tbl('凌水路1号','大连','辽宁','116023','瓷器国'));
最后插入数据报错需要的数据为用户定义类型,请求解决方法
street nvarchar2(30),
city nvarchar2(6),
state nvarchar2(10),
zip varchar2(6),
country nvarchar2(16)
);create type addr_type_tbl is table of addr_type;create table cust1(id varchar2(20),name nvarchar2(20),address addr_type_tbl)nested table address store as address;insert into cust1 values('785411','函数',addr_type_tbl('凌水路1号','大连','辽宁','116023','瓷器国'));
最后插入数据报错需要的数据为用户定义类型,请求解决方法
insert into cust1 values('785411','函数',addr_type_tbl(addr_type('凌水路1号','大连','辽宁','116023','瓷器国')));