title: Update Oracle SQL Query throwing missing right parenthesis error
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>This is the error I am getting</p>
  
  <pre><code>Error report:
  SQL Error: ORA-00907: missing right parenthesis
  00907. 00000 -  "missing right parenthesis"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Whats wrong? Experts please help.. I am new to Oracle 11g</p>