Skip to Main Content
Forums

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!

Case with parameter value in where clause

MagnusGustafsonSep 15 2010 — edited Sep 15 2010
Hi,

I want to construct a where condition containing a case statement with control on a parameter value, something like this:

where case when +:param+ = '1' then column in ('01','04' else column = '02' end

Thanks,
Magnus
This post has been answered by Hoek on Sep 15 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2010
Added on Sep 15 2010
#parameter
4 comments
2,961 views