select table_name, comments from user_tab_comments;
SELECT table_name FROM User_All_Tables;

------解决方案--------------------
汇总各位的如下：
SQL code
SELECT * FROM user_tab_comments;
SELECT * FROM User_All_Tables;
SELECT * FROM tab;
select * from dba_objects where OBJECT_TYPE='TABLE';
select * from all_tables;
SELECT * FROM user_tables ;
SELECT * FROM user_objects ;

------解决方案--------------------
user_tables;