我创建了一个嵌套表,并在嵌套表里插入了记录:
步骤如下:
1、创建了一个对象类型:
CREATE OR REPLACE TYPE address_typ AS OBJECT (
street VARCHAR2(15),
city VARCHAR2(15),
state CHAR(2),
zip VARCHAR2(5)
);2、创建一个嵌套表类型:
create type nested_table_address_typ as table of address_typ;3、创建嵌套表列:
Create Table customer_with_nested_table(
Id Integer Primary Key,
first_name Varchar2(10),
last_name Varchar2(10),
addresses nested_table_address_typ
)
Nested Table
addresses
Store As
nested_addresses;4、在嵌套表中插入数据:
INSERT INTO customer_with_nested_table VALUES (
1, 'Steve', 'Brown',
nested_table_address_typ(
address_typ('2 State Street', 'Beantown', 'MA', '12345'),
address_typ('4 Hill Street', 'Lost Town', 'CA', '54321')
)
);
COMMIT;5、在cmd查询时会出现下面的结果:
ID FIRST_NAME LAST_NAME ADDRESSES
---------- ---------- ---------
1 Steve Brown <Object>在SQL windows里结果也是 ID FIRST_NAME LAST_NAME ADDRESSES
1 Steve Brown <Collection>*********************
就是想问一下怎么把<Object>、<Collection>嵌套表里内容也查出来呀??
步骤如下:
1、创建了一个对象类型:
CREATE OR REPLACE TYPE address_typ AS OBJECT (
street VARCHAR2(15),
city VARCHAR2(15),
state CHAR(2),
zip VARCHAR2(5)
);2、创建一个嵌套表类型:
create type nested_table_address_typ as table of address_typ;3、创建嵌套表列:
Create Table customer_with_nested_table(
Id Integer Primary Key,
first_name Varchar2(10),
last_name Varchar2(10),
addresses nested_table_address_typ
)
Nested Table
addresses
Store As
nested_addresses;4、在嵌套表中插入数据:
INSERT INTO customer_with_nested_table VALUES (
1, 'Steve', 'Brown',
nested_table_address_typ(
address_typ('2 State Street', 'Beantown', 'MA', '12345'),
address_typ('4 Hill Street', 'Lost Town', 'CA', '54321')
)
);
COMMIT;5、在cmd查询时会出现下面的结果:
ID FIRST_NAME LAST_NAME ADDRESSES
---------- ---------- ---------
1 Steve Brown <Object>在SQL windows里结果也是 ID FIRST_NAME LAST_NAME ADDRESSES
1 Steve Brown <Collection>*********************
就是想问一下怎么把<Object>、<Collection>嵌套表里内容也查出来呀??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货