Oracle 查询某张表的字段信息和描述

SELECT
    b.COLUMN_NAME AS column_name,
    b.DATA_TYPE AS column_type,
    A.COMMENTS AS column_comment
FROM
    USER_TAB_COLUMNS b,
    USER_COL_COMMENTS A
WHERE
    b.TABLE_NAME = 'table_name'
AND b.TABLE_NAME = A .TABLE_NAME
AND b.COLUMN_NAME = A .COLUMN_NAME