USER_TAB_COLS使用

SELECT USER_TAB_COLS.TABLE_NAME   AS 表名,
       USER_TAB_COLS.COLUMN_NAME  AS 列名,
       USER_TAB_COLS.DATA_TYPE    AS 数据类型,
       USER_TAB_COLS.DATA_LENGTH  AS 长度,
       USER_TAB_COLS.NULLABLE     AS 是否为空,
       USER_TAB_COLS.COLUMN_ID    AS 列序号,
       USER_COL_COMMENTS.COMMENTS AS 备注
  FROM USER_TAB_COLS
 INNER JOIN USER_COL_COMMENTS
    ON USER_COL_COMMENTS.TABLE_NAME = USER_TAB_COLS.TABLE_NAME
   AND USER_COL_COMMENTS.COLUMN_NAME = USER_TAB_COLS.COLUMN_NAME;