Oracle copy data to another table

oracle, sql

Solution

You need an `INSERT ... SELECT`

INSERT INTO exception_codes( code, message )
  SELECT code, message
    FROM exception_code_tmp

Problem

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"** ```

Original source

Related problems