当我有表名时如何获取模式名 - Oracle

How to get the schema name when I have table name - Oracle

提问by bin

I have a table name but I am not sure in which schema that table exists. How to find the schema name?

我有一个表名，但我不确定该表存在于哪个模式中。如何找到模式名称？

回答by Aleksej

Select owner
from dba_tables
where table_name = 'YOUR_TABLE_NAME'

Hereyou can find something more.

在这里你可以找到更多的东西。

回答by zee

Something like this should get the name of the table and the the schema it belongs to .

这样的事情应该得到表的名称和它所属的架构。

select owner, table_name 
 from all_tables 
 where table_name like 'GL%';