Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Re : Multiple values resut of CASE statement

591793Jan 29 2009 — edited Jan 29 2009
Hello All,

Hope all is well. I was trying to basically return multiple values if a certain value 'X' was passed. for example,

select
case T1.C1
when 'X' then ('XX','YY')
else T1.C1
end
from T1

but I am getting error. I am unable to figure out as to how do you get multiple values out of a single value in SQL. I will then be passing this multiple values as filter in where clause. For example,

where ('XX','YY') in T2.C1

Thanks in advance and let me know if I have missed on something.

- Sam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2009
Added on Jan 29 2009
7 comments
8,737 views