I have two tables that have the same structure except one has an additional column that should be auto-incremented. Sequence and trigger are defined.
I want to copy all data from one table to another using this SQL statement:
INSERT INTO A_WITH_ADDITIONAL_COLUMN SELECT * FROM A;
But I'm getting error:
SQL Error: ORA-00947: not enough values
Which is fine because there is one more column in the target table.
How do I append an additional NULL at the beginning of every row of the source table in order to be able to fill the target WITHOUT enumerating all columns of the source table in the query?