SQL to copy from one table to another

[davide++]

Hi all.

@George1111
Oracle hasn't the concept of AUTOALLOCATE field (I think you mean AUTOINCREMENT field, as Access). Unique values are generated using sequences.

@Endorphin.
I don't understand your requirement. Using the statement

INSERT INTO TABLE2 (id, name, attribute) SELECT (id, name, attribute) FROM TABLE1 WHERE name = :name

you'll get in TABLE2 a full copy of all rows extracted by the query, so id's value of TABLE2 will be the same id's values of TABLE1.
If you want different values, you should use sequences; first create a sequence, for example SEQ_ID_TABLE2, then you can write something like this

INSERT INTO TABLE2 (id, name, attribute) SELECT (SEQ_ID_TABLE2.NEXTVAL, name, attribute) FROM TABLE1 WHERE name = :name

I hope this will help you.