Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL - is inserting of %ROWTYPE variable possible?

Re: PL/SQL - is inserting of %ROWTYPE variable possible?

From: FC <flavio_at_tin.it>
Date: Wed, 08 Jan 2003 13:03:15 GMT
Message-ID: <nkVS9.95277$R45.4486975@news2.tin.it>


Could you please supply a valid reason to do this instead of using more orthodox approaches ?

Bye,
Flavio

"Bogien" <bogien_at_xcom.pl> wrote in message news:3E1B57D3.DDBC8532_at_xcom.pl...
> Hello,
>
> Suppose I have a table named "tab" with columns "a", "b", "c", "d", "e".
> Now, I declare a variable named "rec" of type "tab%ROWTYPE", which
> reflects single record of the table.
>
> Question:
> Can I insert such variable into the table in PL/SQL at once?
>
> So fat, I've been performing this task this way (doesn't look nice...):
> INSERT INTO tab (a, b, c, d, e) VALUES (rec.a, rec.b, rec.c, rec.d,
rec.e);
>
> Is something like "INSERT INTO tab VALUES rec" possible?
>
> Thanks!
>
> PS. I use Oracle 9i, if it can be of any help.
Received on Wed Jan 08 2003 - 07:03:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US