我理解你问的意思,大致是要一个对数据库进行解释性的工具,建议你用下如下sql,并灵活运用:
select ljs.column_name, ljs.comments, lm.DATA_TYPE, lm.DATA_LENGTH
from user_col_comments ljs
inner join user_tab_columns lm
on ljs.table_name = lm.TABLE_NAME
and ljs.column_name = lm.COLUMN_NAME
order by ljs.column_name