Help: XML linking problem in Oracle# Database - 数据库
t*t
1 楼
Suppose I have 2 tables in the database (Oracle9):
create table table1 (table_spec XMLTYPE);
create table table2 (table_spec XMLTYPE);
Then somewhere in the table_spec of data entries of table1 I needed to link to
a node in the XML tree of table_spec in table2. How can I do it? For example,
insert into table1 values (XMLTYPE ('
.....
'));
I understand that XPath can be used here, but exactly how? Especially how to
refer to table2, the path within the XMLTYPE
create table table1 (table_spec XMLTYPE);
create table table2 (table_spec XMLTYPE);
Then somewhere in the table_spec of data entries of table1 I needed to link to
a node in the XML tree of table_spec in table2. How can I do it? For example,
insert into table1 values (XMLTYPE ('
.....
'));
I understand that XPath can be used here, but exactly how? Especially how to
refer to table2, the path within the XMLTYPE