title: Oracle and Sybase compatibility for create table new_table as
body: <p>I am trying to write an SQL query which needs to be compatible on both a Sybase and Oracle database. The query looks like the following :</p>
  
  <pre><code>SELECT * 
    INTO new_table
    FROM other_table
  </code></pre>
  
  <p>This query is working great on a Sybase database but not on an Oracle one. I found the equivalent for Oracle :</p>
  
  <pre><code>CREATE table new_table AS
  SELECT * 
    FROM other_table
  </code></pre>
  
  <p>Is there a way to write a third query that would do the same and that can be executed on a Sybase and on an Oracle database?</p>