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

How about, if the table structure changes already written code won't break unless the field/s being changed in the code between the select and insert are changed?

In the 2+ years that I have been on this project, which was to have gone live 2 years ago, the tables in the DB have changed AT LEAST once a week!

"FC" <flavio_at_tin.it> wrote in message
news:nkVS9.95277$R45.4486975_at_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:58:20 CST