oracle多列转成用逗号分割的一行并去除重复数据
select a.role_name role_name, regexp_replace(listagg(a.perm_name, ',') within group(order by a.perm_name),'([^,]*)(,\1)+($|,)','\1\3') perm_name, regexp_replace(listagg(a.menu_name, ',')...
原创
2020-01-07 14:15:21 ·
1361 阅读 ·
0 评论