查询所有的字段并用,拼接 select group_concat(COLUMN_NAME) '所有字段' from information_schema.COLUMNS where table_name = 'table_name '; select Listagg(column_name, ',') WITHIN GROUP(ORDER BY column_name) from user_tab_columns where table_name = upper('table_name ')