Oracle: listagg() WITHIN GROUP ()函数使用

https://blog.csdn.net/sinat_36257389/article/details/81004843

select table_name,listagg(column_name,',') within group (order by column_name) columnlist from cols where table_name='FXR_PUB_STAGING' group by table_name;

把 table_name 值相同的 column_name 写成一行展示出来

而不是

table_name1  column_name1

table_name1 column_name2

table_name1 column_name3

而是

||table_name||column_name || 

|table_name1 |column_name1,column_name2,column_name3|