Oracle:
CREATE TABLE new_table
AS (SELECT * FROM old_table where 1 <> 1);
Sqlserver:
SELECT *
INTO newtable [IN externaldb]
FROM table1
Where 1 <> 1;
Oracle:
CREATE TABLE new_table
AS (SELECT * FROM old_table where 1 <> 1);
Sqlserver:
SELECT *
INTO newtable [IN externaldb]
FROM table1
Where 1 <> 1;