title: Get the schema name for specific table in SQL/Oracle
body: <p>I am trying to get the schema names for below table on Oracle. Could you please help me to understand whether below query is checking for all the schemas or not.</p>
  
  <pre><code>select * from all_tables
  where table_name like '%ELEC_SURROGATE_KEY';
  </code></pre>
  
  <p>Hoping for some help here.</p>
  
  <p>Thanks!</p>