gmshuang1108的博客

转载 listagg函数：正则表达式去重

select a.xxx, regexp_replace(listagg(b.area_proname,',') within group(order by b.area_proname),'([^,]+)(,\1)+', '\1') as area_proname from table_1a, table_2bwhere a.xx = b.xx...