学习随笔--数据库联合查询--xml查询

最新推荐文章于 2023-09-22 16:30:45 发布

yangqicheng204

最新推荐文章于 2023-09-22 16:30:45 发布

阅读量146

点赞数

分类专栏：数据库文章标签： XML C C++ C#

本文链接：https://blog.csdn.net/yangqicheng204/article/details/83640438

版权

数据库专栏收录该内容

7 篇文章 0 订阅

订阅专栏

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