Oracle查询数据库表、表描述、字段、字段描述的脚本

 

select b.table_name,b.comments tableComments,c.column_name,c.comments columnComments
from user_tab_comments b,user_col_comments c
where b.table_name=c.table_name
--and c.table_name in('CUSTOMER')
order by b.table_name;