Re: INSERT from PL/SQL record

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/05
Message-ID: <339695e1.14100468_at_www.sigov.si>#1/1

On Wed, 04 Jun 1997 05:38:34 -0600, Richard Bolz <dbolz_at_earthlink.net> 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;

No, AFAIK there is no way to directly insert PL/SQL record into coresponding table.

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Thu Jun 05 1997 - 00:00:00 CEST