CREATE TABLE po_clob_tab
(
poid number,
poClob XMLType
);INSERT INTO po_xml_tab
VALUES(100, XMLType('<?xml version="1.0"?>
<PO pono="1">
<PNAME>Po_1</PNAME>
<CUSTNAME>John</CUSTNAME>
<SHIPADDR>
<STREET>1033, Main Street</STREET>
<CITY>Sunnyvalue</CITY>
<STATE>CA</STATE>
</SHIPADDR>
</PO>'));
(
poid number,
poClob XMLType
);INSERT INTO po_xml_tab
VALUES(100, XMLType('<?xml version="1.0"?>
<PO pono="1">
<PNAME>Po_1</PNAME>
<CUSTNAME>John</CUSTNAME>
<SHIPADDR>
<STREET>1033, Main Street</STREET>
<CITY>Sunnyvalue</CITY>
<STATE>CA</STATE>
</SHIPADDR>
</PO>'));
这个我在OracleDOC中也看到过类似的,只是我按照OracleDOC的方法去查询,却查不出所需的XML值,或者说,根本没有任何结果输出,甚至没有错误的信息,所以,还请大哥(姐),能把正确的查询语句,也能告诉我,如果有什么特殊的设置或者应当注意的地方,能够明示,小弟不甚感激!
for example:select SYS_XMLGEN(poClob).getStringVal() from po_clob_tab