title: Search an Oracle database for tables with specific column names?
body: <p>We have a large Oracle database with many tables.  Is there a way I can query or search to find if there are any tables with certain column names?</p>
  
  <p>IE show me all tables that have the columns: <code>id, fname, lname, address</code></p>
  
  <p>Detail I forgot to add: I need to be able to search through different schemas.  The one I must use to connect doesn't own the tables I need to search through.</p>