Skip to content
Advertisement

Oracle case inside where clause

This is a simple question, I’ve read some details about using CASE in WHERE clause, but couldn’t able to make a clear idea how to use it. The below is my sample query:

I have a procedure i_value as in parameter. I need to ignore the 4th line if i_value is ‘S’ and I need to ignore the 5th line if i_value is ‘T’.

Thanks in advance.

Advertisement

Answer

I think this is the best way to solve your problem:

Of course, you could use Dynamic SQL, but it’d be more difficult and less effective.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement