Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: Saving a row
P B wrote:
> I've read a row from a table into a PL/SQL variable, made some change
> (including the primary key) and want to insert it back to the table.
>
> Do I have to list all the 50 columns to do the insertion or I can
> insert the row variable in one shot?
>
> Thanks
Without seeing your code I haven't a clue what you mean by read a row into a variable so that answer is ... don't know because I don't know what you did.
But likely ... it is that you must name the fields.
Daniel Morgan Received on Fri Oct 11 2002 - 14:58:17 CDT