Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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:17:14 CST