SELECT listagg (column_name, ',') WITHIN GROUP (ORDER BY column_name) names
FROM user_tab_columns
WHERE Table_Name='PPCM_SPECLIST_NEW'
oracle 查询表的字段名并合并用逗号隔开
最新推荐文章于 2024-05-01 16:44:51 发布
SELECT listagg (column_name, ',') WITHIN GROUP (ORDER BY column_name) names
FROM user_tab_columns
WHERE Table_Name='PPCM_SPECLIST_NEW'