17,382
社区成员




SQL> with t as
2 (select 1 项目编号, 'abc' 字段1, 'xyz' 字段2, 1234 字段3
3 from dual
4 union all
5 select 1 项目编号, 'abc' 字段1, 'xyz' 字段2, 8888 字段3
6 from dual
7 union all
8 select 1 项目编号, 'abc' 字段1, 'xyz' 字段2, 8833888 字段3
9 from dual
10 union all
11 select 2 项目编号, 'def' 字段1, 'mno' 字段2, 987 字段3
12 from dual
13 union all
14 select 2 项目编号, 'def' 字段1, 'mno' 字段2, 321 字段3 from dual)
15 select 项目编号, 字段1, 字段2, wm_concat(字段3) 字段3
16 from t
17 group by 项目编号, 字段1, 字段2;
项目编号 字段1 字段2 字段3
---------- ----- ----- --------------------------------------------------------------------------------
1 abc xyz 1234,8888,8833888
2 def mno 987,321
SQL>
select 项目编号,字段a,字段b,replace(vm_concat(字段c),',') as 字段c
from table
group by 项目编号,字段a,字段b
with t asSQL> with t as
2 (select 1 项目编号, 'abc' 字段1, 'xyz' 字段2, 1234 字段3
3 from dual
4 union all
5 select 1 项目编号, 'abc' 字段1, 'xyz' 字段2, 8888 字段3
6 from dual
7 union all
8 select 1 项目编号, 'abc' 字段1, 'xyz' 字段2, 8833888 字段3
9 from dual
10 union all
11 select 2 项目编号, 'def' 字段1, 'mno' 字段2, 987 字段3
12 from dual
13 union all
14 select 2 项目编号, 'def' 字段1, 'mno' 字段2, 321 字段3 from dual)
15 select 项目编号, 字段1, 字段2, replace (wm_concat(字段3),',') 字段3
16 from t
17 group by 项目编号, 字段1, 字段2;
项目编号 字段1 字段2 字段3
---------- ----- ----- --------------------------------------------------------------------------------
1 abc xyz 123488888833888
2 def mno 987321
SQL>