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,

[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

Original text of this message