XPost: comp.databases.oracle.misc   
   From: john.g@dot.spamfree.com   
      
   sandy_lucca@yahoo.com (Sandy) wrote:   
      
   >I am trying to do the following:   
   >   
   >EXEC SQL   
   >UPDATE MY TABLE   
   >SET COL1 = :newValue   
   >WHERE COL1 = 0   
   >AND ROWNUM = 1   
   >ORDER BY COL2;   
   >   
   >(index on COL1, COL2)   
   >   
   >Pro*C does not process the "ORDER BY" statement.   
   >   
   >How can I achieve the above   
   >   
   >Thanks   
   >Sandra   
      
   Why are you using an ORDER BY  or ROWNUM in an update statement?   
      
   What are you attempting to accomplish?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)