OraFAQ Forum: SQL & PL/SQL » Multiple WHEN conditions in CASE

Home » SQL & PL/SQL » SQL & PL/SQL » Multiple WHEN conditions in CASE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multiple WHEN conditions in CASE [message #9683]

Mon, 01 December 2003 08:43

Mike Nibeck
Messages: 49
Registered: May 2002

Member

Is there any way of doing something like this:

CASE Process_type IN
WHEN 'A' THEN ....
WHEN 'B' THEN ...
WHEN 'C' OR 'D' ... <----- How can I do this ???
ELSE ....
END CASE;

Report message to a moderator

Re: Multiple WHEN conditions in CASE [message #9685 is a reply to message #9683]

Mon, 01 December 2003 10:45

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You would need to use a searched expression instead of a simple expression:

case
when process_type = 'A' then ...
when process_type = 'B' then ...
when process_type in ('C', 'D') then ...
end case

Report message to a moderator

Previous Topic:	Help on Oracle SQL
Next Topic:	Calculate Time Difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 06:50:25 CDT 2024