title: Oracle SQL how to find out which table has the following two columns?
body: <p>I know of a statement that I can issue to find out the table with the column I am looking for:</p>
  
  <pre><code>SELECT DISTINCT(table_name)
    FROM all_tab_cols 
   WHERE column_name = 'EMP_ID';
  </code></pre>
  
  <p>However, how should I modify this so that I may find the table that has both say <code>EMP_ID</code> and <code>EMP_NAME</code>?</p>