I have what I thought would be a fairly easy thing to do in something
like PL/SQL, but I haven't hit on a solution yet.
I want to be able to select a group of records from a table, and
insert a slightly modified version of the records (key changes) back
into the same table. I'd like to not have to list all the columns in
the table, as there are many. I have been looking at records and
%ROWTYPE as a way to define a record that matches a given tables
schema, but once I get the old row into that record structure, how can
I change a few columns in it, and then insert it back into the same
table?
Received on Mon Jul 22 2002 - 11:44:40 CDT
