从2各数据字典拿信息:all_tab_columns(或user_tab_columns)/all_col_comments(user_col_comments)
例如:
select x.table_name,x.column_name,y.comments
from all_tab_columns x,all_col_comments y
where x.owner = y.owner (+)
and x.table_name = y.table_name (+)
and x.column_name = y.column_name (+)
and x.table_name = 'STORES'