Re: Is IF ELSE statement can be used inside sqlplus?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 12 Jan 2004 09:49:32 +0100
Message-ID: <40025f33$0$7151$626a54ce@news.free.fr>

"Officer" <raboasia_at_pacific.net.sg> a écrit dans le message de news:bttfd7$73t$1_at_nobel2.pacific.net.sg...
> Is it possible to use IF ELSE statement inside sqlplus?
>
> I try to use it couple times, it seems sqlplus does not like it. Any
> example?
>
>

Sorry if double-post.

May be this is what you're searching for:

select case ... when ... then ... when ... then ... else ... end from ...;

For instance:
SELECT CASE
  WHEN day IN
    ('Monday','Tuesday','Wednesday','Thursday','Friday')     THEN 'weekday'
  WHEN day in
    ('Saturday','Sunday')
    THEN 'weekend'
  ELSE 'unknown day' END
FROM DUAL; Regards
Michel Cadot Received on Mon Jan 12 2004 - 02:49:32 CST