Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL - is inserting of %ROWTYPE variable possible?
If the fields being added/deleted are not referenced in the program, I don't
see the point.
If they are referenced, then you are doing something with them in your
programs, so, again, I don't see the point, sooner or later you must deal
with them, I don't understand why selects/inserts are representing an
obstacle.
If you are developing general purpose procedures taking "records" and
"tables" as arguments, then you can take advantage of dynamic SQL for
building the DML statements.
I have the impression that you are trying to translate something from
MS-Access, where you have the "fields" collection and you can enumerate its
members.
But in the end, I still don't understand why it is "necessary" that
approach, please enlighten me.
Bye,
Flavio
"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message
news:08WS9.64524$VA5.10589535_at_news1.news.adelphia.net...
> 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 - 12:39:59 CST