title: Oracle case inside where clause
body: <p>This is a simple question, I've read some details about using <code>CASE</code> in <code>WHERE</code> clause, but couldn't able to make a clear idea how to use it. The below is my sample query:</p>
  
  <pre><code>1    SELECT * FROM dual
  2    WHERE (1 =1)
  3     AND (SYSDATE+1 &gt; SYSDATE)
  4     AND (30 &gt; 40)
  5     AND (25 &lt; 35);
  </code></pre>
  
  <p>I have a procedure <code>i_value</code> 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'.</p>
  
  <p>Thanks in advance.</p>