select * into tblname? 1

[vadimg]

is there an Oracle equivalent of SQL Server's:

select * into new_table from other_table where blah blah?

i want to create a new table with the same schema as 'other_table'

thanks.

 

[Turkbear]

Hi,
Create table table_name as
Select * from other_table;



ps - in Oracle the structure of a table is not its schema - A schema is something that 'owns' objects in the database instance.( usually associated with a user)

 

[vadimg]

thanks......