Oracle 增删改查XML知识点总结&&XMLTypeIndex索引讲解
1.XML多节点更新[注意Oracle的语法内都要是小写才可以不然的话会报错]
Update ZLXA银医通日志Set 结算日志 = Xmlquery('copy $t := $x modify((for $i in $t/Response/响应报文CODE return replace value of node $i with ''B002'') ,(for $i in $t/Response/响应报文MSG return replace value of node $i with ''查询成功'')) return $t' Passing 结算日志 As "x" Returning content)Where GetXMLValue(结算日志, '结帐ID') = 24702314;------------------------或------------------------Update ZLXA银医通日志 ESet E.结算日志 = updatexml(e.结算日志, '/Response/指令ID/text()', r.insid, '/Response/交易流水号/text()', r.obssid,'/Response/转帐日期/text()', r."date", '/Response/转帐时间/text()', r."time", '/Response/响应报文CODE/text()',r.code, '/Response/响应报文MSG/text()', r.msg, '/Response/项目响应报文CODE/text()', r.itemcode,'/Response/项目响应报文MSG/text()', r.itemmsg