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 when 'IN' clause : help

Rajnish ChauhanJun 7 2016 — edited Jun 8 2016

Hi

I have query like below

select * from fileinfo1

where  (CASE WHEN :P106_FILE_TYPE='ALL' THEN file_type IN (1, 2, 11, 12, 21, 22, 81, 82) ELSE :P106_FILE_TYPE END);

when i execute this query its giving me error like below. 'Missing Expression' on IN cluase.


can't we use IN cluase in case when ,or other way solution.

please help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2016
Added on Jun 7 2016
28 comments
20,941 views