Re: How to UPDATE using ROWNUM and ORDER BY

UPDATE MY_TABLE
SET COL1 = :newValue
WHERE COL1 = 0
and col2 = ( select min(col2) from my_table )

Should do it

Pratap Received on Wed Aug 11 2004 - 00:14:10 CDT