逆向wm_concat、listagg

iO_O_Oi

于 2018-10-19 18:05:36 发布

阅读量2.6k

点赞数 2

分类专栏：数据库-oracle 文章标签： wm_concat listagg

本文链接：https://blog.csdn.net/iO_O_Oi/article/details/83186092

版权

本文探讨如何高效地逆向分解使用wm_concat和listagg聚合后的数据，通过实例测试数据和聚合过程，寻求更优的解构方法。

摘要由CSDN通过智能技术生成

1.测试数据：

with tst as(
select '张三' as name,'1' as type,'Z-5678' as phone from dual
union all
select '张三' as name,'2' as type,'Z-7890' as phone from dual
union all
select '张三' as name,'3' as type,'Z-1001' as phone from dual
union all
select '李四' as name,'1' as type,'L-1237' as phone from dual
union all
select '李四' as name,'3' as type,'L-5600' as phone from dual
union all
select '马五' as name,'1' as type,'M-1378' as phone from dual
union all
select '马五' as name,'2' as type,'M-3948' as phone from dual
union all
select '王二' as name,'2' as type,'W-1245' as phone from dual
)