Re: PL/SQL

[Quoted] It's difficult to say what the best solution is without seeing the whole [Quoted] 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 Thu Mar 21 2002 - 18:43:30 CET