I would suggest to look for a SQL tutorial on the net.
"Bill Prew" <billprew_at_cox.net> wrote in message
news:477625b6.0207220844.58109a40_at_posting.google.com...
> 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 - 12:20:15 CDT
