title: SELECT INTO using Oracle
body: <p>I'm trying to do a SELECT INTO using Oracle. My query is:</p>
  
  <pre><code>SELECT * INTO new_table FROM old_table;
  </code></pre>
  
  <p>But I get the following error:</p>
  
  <pre><code>SQL Error: ORA-00905: missing keyword
  00905. 00000 -  "missing keyword"
  </code></pre>
  
  <p>Any ideas what's wrong?</p>
  
  <hr>
  
  <p>The Standard behavior of the above should be as I originally thought:
  However Oracle implemented it totally differently in their own dialect of SQL
  <a href="http://docs.oracle.com/cd/E17952_01/refman-5.0-en/insert-select.html" rel="noreferrer">Oracle Docs on Insert ... Select</a> </p>