表注释

select * from all_tab_comments
where table_name='大写'

select * from all_tab_comments
where comments like 'xxx'

段注释

select * from all_col_comments
where table_name='大写表名'