Possible Duplicate:
Oracle: get list of all tables?
How do I list all tables in a schema in Oracle SQL?可能重复:Oracle:获取所有表的列表?如何在Oracle SQL中列出模式中的所有表?
I want to list all table in another schema.
我想列出另一个模式中的所有表。
connect hr/hr;
select table_name from user_tables;
but I want to skip the "connect" command. I want to run query from another schema. Is that possible to do?
但我想跳过“连接”命令。我想从另一个架构运行查询。这可能吗?
1 个解决方案
#1
16
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER='OTHER-SCHEMA'
#1
16
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER='OTHER-SCHEMA'