title: Oracle delete skip locked
body: <p>Does oracle allows to delete rows from a table with some condition and skip the locked once </p>
  
  <pre><code>DELETE from t 
   WHERE t.id IN (SELECT id 
                    FROM t 
                   WHERE id in ('1','2') 
                     FOR UPDATE SKIP LOCKED )
  </code></pre>
  
  <p>For example id 2 is locked by other session and deletion script should skip that row</p>
  
  <p>The query above always <strong><em>fails with error</em></strong> </p>
  
  <blockquote>
    <p>ORA-00907: missing right parenthesis</p>
  </blockquote>
  
  <p>Version :  Oracle 11G XE </p>