select listagg(COLUMN,',') within GROUP (order by COLUMN) from table_name (11g之后的函数)或者select wm_concat(COLUMN) from table_name
