{{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