–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