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