OraFAQ Forum: Training & Certification » multiple values in then clause of Case statement

Home » Other » Training & Certification » multiple values in then clause of Case statement (Oracle 10g)

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

multiple values in then clause of Case statement [message #339932]

Sat, 09 August 2008 22:50

balcode
Messages: 4
Registered: November 2007

Junior Member

I want to return multiple value in the THEN clause of CASE statement.

SELECT c.company_code, c.com_inactive_flag, e.emp_no
FROM company c, employees e
WHERE c.com_code = e.com_code
AND e.emp_status in (
(CASE c.com_inactive_flag
WHEN 'N' THEN 'A'
WHEN 'Y' THEN 'B,C'
END)

If the flag is N all those employees will be retrieved whoe has status A otherwise all those who have B and C flag should be retrieved.

But because I have 'B,C' so it will not return anything. Is there anyway I can put 'B,C' etc. instead of just one value like 'B'.

Report message to a moderator