{{category Oracle}}
!!!テーブルカラム名取得
 select
     to_char(rownum, 'fm000') seq
   , v.*
 from 
   (
     select 
         tables.table_name
       , comments.comments 
     from 
       user_tables tables
       inner join user_tab_comments comments
          on tables.TABLE_NAME = comments.TABLE_NAME
       inner join user_col_comments colcomments
          on tables.TABLE_NAME = colcomments.TABLE_NAME
     group by
         tables.table_name
       , comments.comments 
     order by 1
   ) v

!!!Link
*[Oracle 豆辞典 ||http://www.venus.dti.ne.jp/~yoshi-o/RDB/Oracle-Beans_dictionary.html]
*[Oracle Tips|http://www.occn.zaq.ne.jp/maekawa/oracletip/]