求大神帮忙啊！！！！

[y3709180]

select c.z,
(wm_concat(c.a || ':' || (select wm_concat(t.a)
from (select 'aa' a, 'zz' z
from dual
union
select 'bb' b, 'zz' z
from dual
union
select 'cc' c, 'zz' z from dual) t
where t.z = c.z
group by t.z))) sky
from (select 'EE' a, 'zz' z
from dual
union
select 'FF' a, 'zz' z
from dual
union
select 'GG' a, 'zz' z from dual) c
group by c.z


要求去掉每个大写前面的“，”

[大明湖畔_帅锅]

什么个数据构造 太模糊了...

[xu176032]

这是想干嘛,, 用正则表达式去不掉么

[super007007007]

with tb as (
select c.z,
       (wm_concat(c.a || ':' || (select wm_concat(t.a)
                                   from (select 'aa' a, 'zz' z
                                           from dual
                                         union
                                         select 'bb' b, 'zz' z
                                           from dual
                                         union
                                         select 'cc' c, 'zz' z from dual) t
                                  where t.z = c.z
                                  group by t.z))) sky
  from (select 'EE' a, 'zz' z
          from dual
        union
        select 'FF' a, 'zz' z
          from dual
        union
        select 'GG' a, 'zz' z from dual) c
 group by c.z
 )
 select z,sky,regexp_replace(sky,',([A-Z]+)','\1',1) from tb