Re: INSERT from PL/SQL record

Dear Richard,

[Quoted] try Insert into T1 ( Select ... From T1 )

(I don't know if the () are right, have a try with and without)

Hope that helps,

Michael Radziej

P.S. When replying, please remove the dontspam part of my mail address.

Richard Bolz wrote:
>
> I have a table, T1, that has many (100+) columns. I would like to
> 1. create a PL/SQL record of the rowtype
>
> REC1 T1%Rowtype;
>
> 2. Fill it with values
>
> 3. Insert it into table T1.
>
> Is there any way to do this in PL/SQL that does not require a lengthy
> VALUES list in the INSERT statement. Something like the following:
>
> INSERT into T1 from REC1;
>
> TIA
>
> Dick
Received on Fri Jun 06 1997 - 00:00:00 CEST