SELECT
tab.COMMENTS 表中文名称,
utc.Table_Name 表名称,
utc.column_name as 字段名,
utc.data_type as 字段类型,
utc.data_length as 数据长度,
utc.data_precision as 数据精度,
utc.nullable as 是否为空,
ucc.comments as 备注
from user_tab_columns utc,user_col_comments ucc,SYS.USER_TAB_COMMENTS tab
where utc.column_name = ucc.column_name and utc.Table_Name = ucc.Table_Name and utc.Table_Name = tab.TABLE_NAME