Re: PL/SLQ question

Anders Blaagaard wrote:
>
> 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

This would work if the list in tmp_row was identical to the default list of columns in your table. You would probably have to explicitely name each of the data elements within the VALUES clause rather than use the group label.

Could there be a unique key that you are not changing?

Good luck, Received on Thu Sep 25 1997 - 00:00:00 CDT