Create table from select in Oracle

Question

I would like to do something like this:

Click to copy

create table NEW_TABLE (select * from OLD_TABLE where id=3582)

And have a new table created from the resulting columns of that select statement.

I bet its possible in mySQL, but how to do it in Oracle?

Answer 1

Try this:

Click to copy

CREATE TABLE new_table AS select * from OLD_TABLE where id=3582