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;
(
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;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货