select a.orderid,
xmltype.extract(value(b),'/orderDetail/@cere__mode').getstringval() model,
xmltype.extract(value(b),'/orderDetail/@number').getstringval() num,
c.type_code,
c.type_content
from
produce_order a,
table(xmlsequence(xmltype.extract(a.xml_content,'/prodOrder/list[@id="detail"]/orderDetail'))) b,
v_raw_material c
where
xmltype.extract(value(b),'/orderDetail/@produceId').getstringval()=c.code
union
select
a.orderid,
xmltype.extract(a.xml_content,'/planOrder/@ggmodel').getstringval() model,
xmltype.extract(a.xml_content,'/planOrder/@num').getstringval() num,
b.type_code,
b.type_content
from produce_plan_order a,v_raw_material b
where
xmltype.extract(a.xml_content,'/planOrder/@cpid').getstringval()=b.code
union
select
a.orderid,
xmltype.extract(value(b),'/orderDetail/@cereMode').getstringval() model,
xmltype.extract(value(b),'/orderDetail/@number').getstringval() num,
c.type_code,
c.type_content
from c_bg_maintain_outstore_order a,
table(xmlsequence(xmltype.extract(a.xml_content,'/clientBackMaintainOutStoreOrder/list[@id="detail"]/orderDetail'))) b,
v_raw_material c
where
xmltype.extract(value(b),'/orderDetail/@produceId').getstringval()=c.code
学习随笔--数据库联合查询--xml查询
最新推荐文章于 2023-09-22 16:30:45 发布