title: How to find tables with two column names in a database
body: <p>I am trying to find a table in a database that has two column names. If I try to search the DB for a table with one column name I am able to pull back a list of table names that has that column, but when I do it for 2 columns I pull back nothing.</p>
  <p>Here is what I have been using:</p>
  <pre><code>select table_name from all_tab_columns
  where column_name = 'COLUMN_1' and column_name = 'COLUMN_2'
  </code></pre>