PL/SQL
From: Laurent Boutet <laurent.boutet1_at_libertysurf.fr>
Date: Wed, 20 Mar 2002 17:17:14 +0100
Message-ID: <a7acet$gv8$1_at_reader1.imaginet.fr>
Hi,
Date: Wed, 20 Mar 2002 17:17:14 +0100
Message-ID: <a7acet$gv8$1_at_reader1.imaginet.fr>
Hi,
[Quoted] Here is my question :
[Quoted] [Quoted] In my stored proc, I copy 2 times likely the same code. I mean, the code is [Quoted] just a bit different for instance :
[Quoted] if param=1 then
[Quoted] 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 [Quoted] would have select * from table2;
[Quoted] How can I do such a thing ??????
I hope you understand my problem...
Thanks in advance,
Laurent
Received on Wed Mar 20 2002 - 17:17:14 CET