title: sqlplus SELECT from the selected result
body: <p>I am using Oracle sqlplus and am trying to use the result being selected from the codes below and select the column again from Table_1</p>
  
  <pre><code>SELECT * 
  FROM
  (
  SELECT Column_Name 
  FROM All_Tab_columns 
  WHERE Table_Name=UPPER('Table_1')
  )
  INTERSECT
  (
  SELECT Column_Name 
  FROM All_Tab_columns 
  WHERE Table_Name=UPPER('Table_2')
  );
  </code></pre>
  
  <p>How can I perform something like that:</p>
  
  <pre><code>SELECT &lt;Columns_That_Intersected&gt;
  FROM Table_1;
  </code></pre>
  
  <p>Is it possible to store the Columns_That_Intersected in a variable/function/procedure and use it again for other select statement?</p>