Re: Conditional statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 19 Oct 1999 15:18:49 GMT
Message-ID: <380c8b7e.29103659@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 - 10:18:49 CDT