查询Oracle数据库的表名及列名注释

废话不多说，直接在PLSQL控制台 运行SQL即可

 SELECT t.table_name table_name,
       t.comments table_comments,
       t1.column_name column_name,
       t2.DATA_TYPE || '(' || t2.DATA_LENGTH || ')' date_type,
       t1.COMMENTS column_comments
 FROM user_tab_comments t, User_Col_Comments t1, User_Tab_Cols t2
 WHERE t.table_name = t1.table_name
   AND t2.column_name = t1.column_name
   AND t2.table_name = t1.table_name
   AND t.table_name not like '%$%'; --加条件，限制不需要导出的表结构