Create table (structure and data) from existing table in oracle

Question

I want to create (and fill) a table similar to an existing table in Oracle (PL-SQL).

I used this code (extracted from this question):

Select * into NewTable from OldTable

but this error occurred:

ORA-00905: missing keyword

I think this code works only in SQL-Server. so how can I handle it in Oracle?

`select into t2 from t1` is SQL Server syntax for copying a table. In Oracle `select into` is for something different. — William Robertson, Jul 23 '17 at 09:55

Cyrus · Accepted Answer · 2017-07-23T14:34:18.803

1

CREATE TABLE NewTable AS SELECT * FROM OldTable

edited Jul 23 '17 at 14:34

answered Jul 23 '17 at 06:17

Cyrus

1 Answers1