oracle 解析XML

分类: 文章 • 2024-05-13 20:57:04

--解析xml，并获得xml数据的值
select x.wf_orunid,extractvalue(xmltype(X.XMLDATA),'/Items/WFItem[@name="WH"]') as wh
,b.swh as swh
from bpm_archiveddata x,oa_bpm_docincome b
--多表关联查询更新数据
update (
select x.wf_orunid,extractvalue(xmltype(X.XMLDATA),'/Items/WFItem[@name="WH"]') as wh
,b.swh as swh
from bpm_archiveddata x,oa_bpm_docincome b where x.wf_orunid=b.wf_orunid)

set swh=wh