Re: Conditional statement
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 19 Oct 1999 15:18:49 GMT
Message-ID: <380c8b7e.29103659_at_news.demon.nl>
Date: Tue, 19 Oct 1999 15:18:49 GMT
Message-ID: <380c8b7e.29103659_at_news.demon.nl>
On Tue, 19 Oct 1999 10:02:12 -0400, "Shelly Varghese(pnu)" <shelly.varghese_at_am.pnu.com> wrote:
>I have a multiple level of
> if.. then.. else,
>can i have something similar to Select.. Case or Swith.... break. this has
>to be written in a stored procedure PL/SQL .
>I tried to use decode, but was difficult in this case.
>
>My last option will be writing "if... then... else"
>
>Thanks
>
>Shelly
>
>
if <cond1> then
statement1;
elsif <cond2> then
statement2;
elsif <cond3> then
statement3;
end if;
is the pl/sql equivalent of select case
Hth,
Sybrand Bakker, Oracle DBA
Received on Tue Oct 19 1999 - 17:18:49 CEST