title: Creating temporary table without knowing the columns in oracle
body: <p>How to create a temporary table in oracle without knowing the number and name of columns.</p>
  
  <p>For example:</p>
  
  <pre><code>Select columnA,columnB,* into temp_table from tableA.
  </code></pre>
  
  <p>Here,tableA maynot be a simple tablename but maybe derived from many queries.</p>
  
  <p><em>How can this be achieved?Is there any alternative to this?</em></p>