select max(sys_connect_by_path(column_name,','))
from(select column_name,column_id from user_tab_columns where table_name='TABLE_NAME')
start with column_id = 1
connect by column_id = rownum
from(select column_name,column_id from user_tab_columns where table_name='TABLE_NAME')
start with column_id = 1
connect by column_id = rownum