Oracle copy data to another table

Question

In the Oracle  I copy data from a backup to a new table  it doesn t work    what is the correct syntax    Thanks  select CODE  MESSAGE into EXCEPTION CODES  CODE  MESSAGE  from Exception code tmp   the error is     SQL Error  ORA-00905  missing keyword 00905  00000 -   missing keyword

User · Answer

Creating a table and copying the data in a single command   create table T NEW as   select   from T      This will not copy PKs  FKs  Triggers  etc

User · Answer

You need an INSERT     SELECT  INSERT INTO exception codes  code  message     SELECT code  message     FROM exception code tmp

User · Answer

If you want to create table with data   First create the table    create table new table as   select   from old table      and then insert   insert into new table   select   from old table     If you want to create table without data   You can use    create table new table as   select   from old table where 1 0

User · Answer

create table xyz new as select   from xyz where 1 0    http   www codeassists com questions oracle copy-table-data-to-new-table-in-oracle

User · Answer

insert into EXCEPTION CODES  CODE  MESSAGE  select CODE  MESSAGE from Exception code tmp

[sql] Oracle copy data to another table

Examples related to sql

Examples related to oracle