Oracle查询表名和表的注释

--查询表名及说明
select distinct table_name,comments from(
select a.table_name, b.comments
from user_tables a, ALL_TAB_COMMENTS b
where a.table_name = b.table_name) aa
where table_name = '表名';