Oracle search for table inside all schemas

example


SQL> select owner, table_name 
2 from all_tables 
3 where table_name like 'GL%';