oracle解析xml
oracle数据库解析xml
select extractvalue(xmltype(XML列),'/cisReports/cisReport/queryConditions/item/name]') as 别名h
from INTERFACE_INFO ii,ORDER_INFO oi
where oi.id=ii.fk_order_id
and II.type >100206
and oi.ORDER_STATE>40002
extractvalue 只支持单个节点(那么节点)
ex
原创
2020-07-10 20:59:27 ·
650 阅读 ·
0 评论