Thanks for the reply Helen

>Assuming in both cases you are using generator + trigger to populate

the
PK:

>insert into table1 (col2, col3, col4, .....)
>select col2, col3,col4, ... from table1
>where blah...

I can't use Insert since the row already exists, I just want to
overwrite
all the columns in a row , prior to doing other modifications on an
individual column, e.g. changing the name in the NAME column.

Jack