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?

Answer 1

CREATE TABLE NewTable AS SELECT * FROM OldTable