I'm trying to do a SELECT INTO using Oracle. My query is:
SELECT * INTO new_table FROM old_table;
SQL Error: ORA-00905: missing keyword
00905. 00000 - "missing keyword"
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 /