title: "Missing keyword" in CASE in Oracle SQL
body: <p>I have this <code>CASE</code> in the <code>where</code> clause but when I tried to save, the &quot;missing keyword&quot; error appears. The goal of this is to check if <code>a.term_date</code> is <code>null</code> then <strike>set</strike> add a condition that <code>:prm_date</code> is to be <code>not between b.date and c.date</code> and vice versa.</p>
  <p>The code goes:</p>
  <pre><code>and ( 1 = CASE
            WHEN a.term_date is null then :prm_date between b.date and c.date
            ELSE :prm_date not between b.date and c.date 
            END )
  </code></pre>
  <p>I am not very sure if this is the best way to do this.</p>
  <p>:prm_date is a date parameter that a user enters</p>