PL/SQL

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 Wed Mar 20 2002 - 10:16:39 CST