Re: Copying rows in PL/SQL

Bill Prew wrote:

> 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?

It can only be done if you list the column names.

Daniel Morgan Received on Mon Jul 22 2002 - 13:01:44 CDT