Re: How to UPDATE using ROWNUM and ORDER BY
From: Pratap <pratap_fin_at_rediffmail.com>
Date: 10 Aug 2004 22:14:10 -0700
Message-ID: <830861d2.0408102114.51d756e3_at_posting.google.com>
Date: 10 Aug 2004 22:14:10 -0700
Message-ID: <830861d2.0408102114.51d756e3_at_posting.google.com>
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 - 07:14:10 CEST