java解析clob的xml数据_使用Oracle中的CLOB列提取查询xml

你需要指定命名空间，请尝试下一个查询

select extract(xmltype('

xmlns:testsystem="http://test.com/testSystem"

xmlns:tns="http://google.com/testService/">

2014-2015

'),'/input/ProcessData/reviewYear/text()', 'xmlns="http://google.com/testsystem" xmlns:testsystem="http://test.com/testSystem" xmlns:tns="http://google.com/testService/"').getStringVal() as data

from dual

UPD .

更新尝试

select updatexml(xmltype('

xmlns:testsystem="http://test.com/testSystem"

xmlns:tns="http://google.com/testService/">

2014-2015

'), '/input/ProcessData/reviewYear/text()', '2013-2014',

'xmlns="http://google.com/testsystem" xmlns:testsystem="http://test.com/testSystem" xmlns:tns="http://google.com/testService/"').getclobval() as data

from dual