title: Is there any alternative of skip locked for update in oracle
body: <p>I have 5 rows in table. And some of the rows are locked in some sessions .<br>
  I don't want to generate any error, Just want to wait until any row will become free for further processing</p>
  
  <p>I tired with nowait and skip locked:-</p>
  
  <ol>
  <li><p>nowait , But there is a problem with nowait. query has written in cursor , when I used "nowait" under cursor , query will return null and control will go out with an error by saying- resource busy</p></li>
  <li><p>I tried with skip locked with for update-But if table contain 5 rows and all 
  5 rows are locked then it is giving error. </p></li>
  </ol>
  
  <p><code>CURSOR cur_name_test IS
  SELECT def.id , def.name
    FROM def_map def
   WHERE def.id = In_id
     FOR UPDATE skip locked;</code></p>