oracle 一列数据转换为字符串 LISTAGG函数
排序:
SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name) AS concatenated_string FROM your_table;
不排序:
wmsys.wm_concat('{'||sceneName||'}')
排序:
SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name) AS concatenated_string FROM your_table;
不排序:
wmsys.wm_concat('{'||sceneName||'}')