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
– William Robertson, Commented Jul 23, 2017 at 9:55

Cyrus · Accepted Answer · 2017-07-23 14:34:18Z

1

CREATE TABLE NewTable AS SELECT * FROM OldTable

answered Jul 23, 2017 at 6:17

Cyrus

2,1952 gold badges15 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1