title: Query which will bring table names according column name
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1953239/oracle-column-query-or-search">Oracle column query or search</a>  </p>
  </blockquote>
  
  
  
  <p>I need a query which will bring name of the tables that contains that column name in oracle.</p>
  
  <p><strong>Example:</strong> Lets say that I have <code>table1</code> with columns <code>(a,b)</code>, <code>table2</code> with columns <code>(b,c)</code> and <code>table3</code> with columns <code>(a,b,c,d)</code> so I need a know which tables contain <code>C</code> column so I need a query which will bring table names, how I can do that ? </p>
  
  <p>Thanks</p>