select * from user_tab_comments t where t.table_name ='XXX' select * from user_col_comments c where c.table_name ='XXX' and c.column_name ='YYY'