获取某表的所有字段

select  listagg(COLUMN_NAME,',')within group(order by COLUMN_NAME)name 

from all_tab_columns

where table_name = '表名';