title: Oracle, 2 procedures avoid deadlock
body: <p>I have two procedures that I want to run on the same table, one uses the birth date and the other updates the name and last name taken from a third table.</p>
  
  <p>The one that uses the birthday to update the age field runs all over the table, and the one that updates the names and last name only updates the rows that appear on the third table based on a key.</p>
  
  <p>So I launched both and got deadlocked! Is there a way to prioritize any of them? I read about the <code>nowait</code> and skip locked for the update but then, how would I return to the ones skipped?</p>
  
  <p>Hope you can help me on this!!</p>