title: How to write an UPDATE statement when we need to check a condition?
body: <p>I want to write an update statement in Oracle SQL to set True to a few properties only when another property in the same table is true.</p>
  <pre class="lang-none prettyprint-override"><code>    name   |    value
  ----------------------
  property1       False
  property2       False
  property3       True
  </code></pre>
  <pre><code>UPDATE table_xyz 
     SET value = 'True' 
  WHERE name in ('property1', 'property2') 
  </code></pre>
  <p>only when property3 = 'True';</p>