Duplicating records with some columns changing..

Hi all,
I have an Oracle table with a lot of columns. I would like to duplicate a record of this table changing only a field (that is part of primary key): how can I do it with SQL instruction? It will be annoying to write all fields in insert statement and select statement

thanks in advance Received on Thu Jan 10 2002 - 11:18:33 CET