title: missing right parenthesis with update statment
body: <p>i am trying to make a normal update statement . </p>
  
  <pre><code>update adm_types_uda set type_id =28202 where recid in (
  SELECT  recid FROM 
      (
      SELECT *FROM adm_types_uda 
      ORDER BY recid desc
      )
  WHERE rownum &lt;= 284
  ORDER BY recid ) 
  </code></pre>
  
  <p>it gives me </p>
  
  <pre><code>SQL Error: ORA-00907: missing right parenthesis
  </code></pre>
  
  <p>the inner select between in worked well independent . </p>
  
  <p>i try to give all select an alias but still give the same error </p>
  
  <pre><code>update adm_types_uda uda set uda.type_id =28202 where uda.recid in (
  SELECT  gd.recid FROM 
      (
      SELECT * FROM adm_types_uda u
      ORDER BY u.recid desc
      ) gd
  WHERE rownum &lt;= 284
  ORDER BY gd.recid)
  </code></pre>
  
  <p>can any one help ?</p>