Oracleの最近のブログ記事

select tab.table_name,
col.column_id,
col.column_name,
com.comments
from user_tables tab
left join user_tab_columns col
on tab.table_name = col.table_name
left join user_col_comments com
on col.table_name = com.table_name
and col.column_name = com.column_name
where tab.table_name = '(テーブル名)'
order by col.column_id

備忘録です(^-^;