title: Oracle update query set a value to true out of two values even when false is passed
body: <p>I have following Oracle update query to set count and event hit.</p>
  
  <pre><code>update iam_counts
       set count = count + 1, event_hit = :eventHit
     where row_id = :rowId
  </code></pre>
  
  <p>Count is number type and event_hit is char type (T or F)</p>
  
  <p>This query is called from two methods alternatively. Method 1 with event hit false and Method 2 with event hit true.</p>
  
  <p>In both cases, count should be updated and for event hit it should be set to true like below</p>
  
  <ul>
  <li>Method 1 call - false</li>
  <li>Method 2 call - true</li>
  <li>Method 1 call - true ----> Even though event hit is false it should be set as true</li>
  </ul>
  
  <p>Is there a functionality like check or query to achieve it.</p>