取得 Oracle Table 和 Column 的註解

-- 取得 Table 註解
select table_name, comments
from sys.user_tab_comments
where table_type ='TABLE'
and comments is not null
;

-- 取得 Column 註解
select table_name, column_name, comments
from sys.user_col_comments
where comments is not null
;