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