Oracle查询表的所有列名和列名注释

因业务需求,需要列出某一表的所有列名返回前端,以供用户来下拉选择并填写条件来筛选数据

SELECT
    ROWNUM as PARAMETER_ID,
    t.COLUMN_NAME as COLUMN_NAME,
    COMMENTS AS PARAMETER_NAME,
    t.DATA_TYPE AS DATA_TYPE
FROM
    user_tab_columns t,
    user_col_comments c
WHERE t.COLUMN_NAME = c.COLUMN_NAME
  AND t.Table_Name = #{tableName}
  AND c.Table_Name = #{tableName}

效果如下: