SELECT INTO using Oracle
If NEW_TABLE already exists then … insert into new_table select * from old_table / If you want to create NEW_TABLE based on the records in OLD_TABLE … create table new_table as select * from old_table / If the purpose is to create a new but empty table then use a WHERE clause with a condition … Read more