sql - Select oracle schema which only contains specific table -


i'm looking way select schema on oracle server, contain table "mytable"

how can ?

i have query list schema in database.

select username all_users; 

thank !

you can on all_tables system table:

select distinct owner all_tables table_name = 'mytable' 

Comments

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

keyboard - C++ GetAsyncKeyState alternative -

android - java.net.UnknownHostException(Unable to resolve host “URL”: No address associated with hostname) -