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 :

```
SELECT * 
  INTO new_table
  FROM other_table

```

This query is working great on a Sybase database but not on an Oracle one. I found the equivalent for Oracle :

```
CREATE table new_table AS
SELECT * 
  FROM other_table

```

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?