How can I append a column to an inner SQL statement? 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?
INSERT INTO A_WITH_ADDITIONAL_COLUMN (newcol, col1, col2, col3,...)
    SELECT NULL, A.col1, A.col2,a.col3,..... FROM A;

Should do what you're asking.