Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to UPDATE using ROWNUM and ORDER BY

How to UPDATE using ROWNUM and ORDER BY

From: Sandy <sandy_lucca_at_yahoo.com>
Date: 10 Aug 2004 07:43:29 -0700
Message-ID: <f2c5a2a1.0408100643.841f9eb@posting.google.com>


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 Received on Tue Aug 10 2004 - 09:43:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US