获取Oracle数据库的不同模式中的表名列表[重复]

时间:2021-10-16 15:00:35

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'