Oracle 字典表

–DBA 用户下

SELECT t.OWNER,t.table_name,a.comments table_comments ,t.column_name, t.comments
from dba_col_comments t, dba_tab_comments a
WHERE t.table_name = a.table_name

–当前用户下

SELECT t.table_name,a.comments, t.column_name, t.comments
from user_col_comments t, user_tab_comments a
WHERE t.table_name = a.table_name