Re: How to UPDATE using ROWNUM and ORDER BY

UPDATE MY_TABLE
SET COL1 = :NEWVALUE
WHERE ROWID =
(SELECT ROWID
 FROM MY_TABLE
 WHERE COL1 = 0
   AND ROWNUM = 1
 ORDER BY COL2) Received on Fri Aug 13 2004 - 13:58:41 CDT