SELECT 
    col.OWNER AS "库名",
    col.TABLE_NAME AS "表名",
    tab_comm.COMMENTS AS "表中文备注",
    col.COLUMN_NAME AS "列名",
    col.DATA_TYPE AS "数据类型",
    col.DATA_TYPE AS "字段类型",
    col.DATA_LENGTH AS "长度",
    col.NULLABLE AS "是否为空",
    col.DATA_DEFAULT AS "默认值",
    col_comm.COMMENTS AS "备注"
FROM 
    ALL_TAB_COLUMNS col
LEFT JOIN 
    ALL_COL_COMMENTS col_comm
ON 
    col.OWNER = col_comm.OWNER 
    AND col.TABLE_NAME = col_comm.TABLE_NAME 
    AND col.COLUMN_NAME = col_comm.COLUMN_NAME
LEFT JOIN
    ALL_TAB_COMMENTS tab_comm
ON 
    col.OWNER = tab_comm.OWNER
    AND col.TABLE_NAME = tab_comm.TABLE_NAME
WHERE 
    col.OWNER = 'SC_ENTERPRISE_DATA_CENTER'
ORDER BY 
    col.TABLE_NAME, col.COLUMN_ID;

SELECT CONCAT(表名) 实体, SUBSTRING(GROUP_CONCAT(',',CONCAT(列名,' (',数据类型,')')) , 2)属性 from ccd
WHERE 列名 not in ('flag','id') and 表名 is not null GROUP BY 表名