oracle 聚合函数 LISTAGG ,将多行结果合并成一行
select x.*,y.fcloudfieldname from ( select t1.fid, t1.ffromid ,t1.ffromname,t1.fexplain,t1.fcrmbodyname, (case when t1.fexplain like 'CRM%' then 'HANSJGCRMToK3Cloud.BLL.'|| t1.ffromid || 'Bll;SaveOrder;' || t1.ffromid ||';' || t1.fcrmsname || ';[Service Agreement.Id]=''1-DLSSRU'';1-DLSSRU' else 'HANSJGCRMToK3Cloud.OABLL.'|| t1.ffromid || 'Bll;SaveOrder;' || t1.ffromid ||';' || t1.fcrmsname || ';[Service Agreement.Id]=''1-DLSSRU'';1-DLSSRU' end ) formateFcrmsnam ,fcrmsname FROM HANS_T_CRMCLOUDFIELD T1 order by t1.fcrmsname, t1.fexplain ) x inner join ( select t2.fid ,listagg(nvl(to_char(t2.fcloudfieldname),''),' 、 ') within group(order by t2.fid) as fcloudfieldname from HANS_T_CRMCLOUDFIELDENTRY t2 group by t2.fid ) y on x.fid=y.fid
输出:
oracle 聚合函数 LISTAGG ,将多行结果合并成一行
select x.*,y.fcloudfieldnamefrom (select t1.fid, t1.ffromid ,t1.ffromname,t1.fexplain,t1.fcrmbodyname,(case when t1.fexplain like ...
点击下载文档
本文2024-09-16 18:37:55发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-23394.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章