select x.*
from xmltable( '/root/healthExamination/examination' /*xpath到当前节点表达式*/ passing
xmltype('<?xml version="1.0" encoding="utf-8"?>
<root version="1.0" sender="mbelec">
<healthExamination>
<examination><argumentName>血压状态</argumentName><argumentValue>0</argumentValue><argumentUnit /></examination>
<examination><argumentName>事件类型</argumentName><argumentValue>1</argumentValue><argumentUnit /></examination>
<examination><argumentName>收缩压</argumentName><argumentValue>103</argumentValue><argumentUnit>mmHg</argumentUnit></examination>
<examination><argumentName>舒张压</argumentName><argumentValue>74</argumentValue><argumentUnit>mmHg</argumentUnit></examination>
<examination><argumentName>平均压</argumentName><argumentValue>83</argumentValue><argumentUnit>mmHg</argumentUnit></examination>
<examination><argumentName>血压脉搏</argumentName><argumentValue>69</argumentValue><argumentUnit /></examination>
</healthExamination>
</root>')
columns
argumentName varchar2(30) path '/examination/argumentName' /*XPath 轴表达式*/,
argumentValue varchar2(30) path '/examination/argumentValue'
) x;
两个节点都有相同的code,所以两个节点的信息都会获取到