SELECT *
FROM ALL_OBJECTS A ,
ALL_TAB_COMMENTS B
WHERE A.OWNER='SYSTEM'
AND A.OBJECT_TYPE='TABLE'
And A.OBJECT_NAME=B.TABLE_NAME
AND A.OWNER=B.OWNER
AND A.OBJECT_TYPE=B.TABLE_TYPE
FROM ALL_OBJECTS A ,
ALL_TAB_COMMENTS B
WHERE A.OWNER='SYSTEM'
AND A.OBJECT_TYPE='TABLE'
And A.OBJECT_NAME=B.TABLE_NAME
AND A.OWNER=B.OWNER
AND A.OBJECT_TYPE=B.TABLE_TYPE
from all_objects a,all_tab_comments b
where a.object_name = b.table_name
and a.owner='user_name'
and a.object_type='TABLE'
AND A.OBJECT_TYPE='TABLE'
And A.OBJECT_NAME=B.TABLE_NAME这三个条件肯定是必须的。是唯一确定OBJECT的
这个在我的机器上才Executed in 0.454 seconds
你试一下!