Oracle中取所有用户表及表描述

select rownum as No,Table_Name as TabName, Comments as TabDes from 
(select a.Table_Name,a.OWNER,b.Comments,b.Table_Type from all_tables a left join user_tab_comments b
on a.TABLE_NAME=b.table_name
) c where owner='表用户名' and Table_Type='TABLE'

似乎直接用下面的一句也可以，Oracle每建一个表，就会在表描述中插一条记录

select Table_Name，Comments from user_tab_comments where Table_Type='TABLE'