title: Deadlock in Oracle
body: <p>I am getting deadlock while running the below queries in Oracle</p>
  
  <pre><code>update MYTABLE 
     set COLUMN1 = COLUMN1 + 589 
   where COLUMN1 &gt;= 7988 
     and COLUMN1 &lt;= 7988
  
  update MYTABLE 
     set COLUMN1 = COLUMN1 + 660 
   where COLUMN1 &gt;= 7840
  </code></pre>
  
  <p>How come I will get a deadlock when both the queries are running in 2 separate Transactions?
  My point is the second query will wait until the first query finishes its Transaction when the isolation is set to <code>READCOMMITTED</code> right?</p>
  
  <p>Is there any hint I can apply to avoid deadlock?</p>
  
  <p>Note: <code>COLUMN1</code> is not a PK in that table, however application ensures that there are no duplicates.</p>