Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL
ho! ho!
Your solution might interest me....
Would you mind giving an exemple please ????
Thanks very much in advance....
Laurent
"Richard Kuhler" <noone_at_nowhere.com> a écrit dans le message de news:
6Zom8.53$Q2.165197_at_twister.socal.rr.com...
> It's difficult to say what the best solution is without seeing the whole
> picture. However, you might consider dynamically creating a private
> synonym at the beginning of the code to point to the correct table.
> Then just use the synonym everywhere in the rest of the code.
>
> Richard Kuhler
>
> Laurent Boutet wrote:
> >
> > Hi,
> >
> > Here is my question :
> >
> > In my stored proc, I copy 2 times likely the same code. I mean, the code
is
> > just a bit different for instance :
> >
> > if param=1 then
> > select * from table1;
> > else
> > select * from table2;
> >
> > This is a very basic code...but imagine I have hundred lines !!!
> > If only I could do such a code :
> > select * from table<param>
> >
> > So I would just have to set the param value...for instance, param=2
then, I
> > would have select * from table2;
> >
> > How can I do such a thing ??????
> >
> > I hope you understand my problem...
> >
> > Thanks in advance,
> > Laurent
>
Received on Fri Mar 22 2002 - 02:12:42 CST