PL/SLQ question

I have a table with more than 100 columns, and a want to make a copy of a row, change a few fields, a put it back into the table (without changing the original). The idea is this:

declare
  tmp_row table_name%rowtype;
begin
  select * into tmp_row from table_name where ...   tmp_row.field37 := ..
  tmp_row.field98 := ..
  insert into table_name values (tmp_row); -- ILLEGAL end;

Can anyone think of an easy way to do this?

Anders Blaagaard
blaa_at_ifad.dk Received on Tue Sep 23 1997 - 00:00:00 CDT