What's the easiest way to duplicate a column?

Question

Currently, I'm getting the ID of the column via a select statement and insert all the returned values (except the ID).

Is there an easier way to do it?

Answer 1

I don't know Oracle one bit, but there should be an equivalent to

INSERT INTO TABLENAME select * FROM tablename WHERE id = x