Re: How to UPDATE using ROWNUM and ORDER BY
From: Kevin <kk2796_at_hotmail.com>
Date: 13 Aug 2004 11:58:41 -0700
Message-ID: <5a1dc659.0408131058.78d2362a_at_posting.google.com>
Date: 13 Aug 2004 11:58:41 -0700
Message-ID: <5a1dc659.0408131058.78d2362a_at_posting.google.com>
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 - 20:58:41 CEST