--解析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
扫一扫
1653
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
