INSERT from PL/SQL record

From: Richard Bolz <dbolz_at_earthlink.net>
Date: 1997/06/04
Message-ID: <339553BA.5A7_at_earthlink.net>#1/1


[Quoted] [Quoted] 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 Wed Jun 04 1997 - 00:00:00 CEST

Original text of this message