oracle ref table column 插入数据问题
CREATE TYPE ADDRESS AS OBJECT
(
street VARCHAR2(200),
city VARCHAR2(200),
state CHAR(2),
zip VARCHAR2(20)
)
;
create table customers1(id number,adress ADDRESS);
create table customers2(id number,adress ref ADDRESS);
insert into customers1(account, adress) values(123, ADDRESS('FX', 'TT', 'GP', 510000));
insert into customers2(account, adress) values(123, ADDRESS('FX', 'TT', 'GP', 510000));
以上是SQL代码,为什么第二句insert语句插入数据的时候报
0RA-00932:inconsistant datatypes:expected REF XXXX.ADDRESS got XXXX.ADDRESS.
创建customers2的时候adress列使用了ref关键字,能有朋友跟我说下这两个用法的区别吗?能详细说下,谢谢~再者,想插入customers2表数据的时候,我现在只知道这么做,如下
CREATE TABLE customer_ref OF ADDRESS;
INSERT INTO customer_ref VALUES('FX', 'TT', 'GP', 2333);
insert into customers2 select 11, ref(t) from customer_ref t;