转自:https://blog.csdn.net/u011497507/article/details/79580442
1.查询当前用户下的所有表
select table_name from user_tables;
2.查询当前实例的所有用户及表信息
select distinct a.OWNER 用户名, a.TABLE_NAME 表名
from sys.all_col_comments a,
sys.dba_objects b
where a.table_name=b.object_name
and b.object_type='TABLE'
order by a.OWNER, a.TABLE_NAME;