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
Post a Comment