Create table from select in Oracle

sql database oracle oracle9i
IAdapter picture IAdapter · Dec 21, 2011 · Viewed 7.2k times · Source

I would like to do something like this:

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

Telmo Marques picture Telmo Marques · Dec 21, 2011

Try this:

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

Related questions

Best way to do multi-row insert in Oracle?

I'm looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but doesn't seem to be supported in Oracle. INSERT INTO TMP_DIM_EXCH_RT (EXCH_WH_KEY, EXCH_NAT_KEY, EXCH_…

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More