你需要指定命名空间,请尝试下一个查询
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