oracle 解析XML
--解析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)
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