title: Select into a temporary table in Oracle
body: <p>I am trying to do something like the following,</p>
  
  <pre><code>select * into temp from (select * from student);
  </code></pre>
  
  <p>It gives me the following error,</p>
  
  <pre><code>ERROR at line 1:
  ORA-00905: missing keyword
  </code></pre>
  
  <p>In my real example the subquery (select * from student) is more complex.</p>
  
  <p>I want to use this in a stored procedure, so I don't want to create the table itself. I just want to make my code more readable by using a temp table.</p>