title: Update Query with select and row lock
body: <pre><code>update mytable set node_index=0 where id in (
          SELECT 
              id
           FROM mytable
           WHERE 
              rownum&lt;=10 and PROCS_DT is null  
           order by CRET_DT,PRTY desc) 
  </code></pre>
  
  <p>I got this query as part of a previous answer to my question. Now how to lock the rows in the select query to make sure no other thread over writes my update.</p>