Re: How to UPDATE using ROWNUM and ORDER BY
From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 10 Aug 2004 10:54:23 -0500
Message-ID: <brrhh0to69da4mchq6iu8vhmru83e1ic28_at_4ax.com>
Date: Tue, 10 Aug 2004 10:54:23 -0500
Message-ID: <brrhh0to69da4mchq6iu8vhmru83e1ic28_at_4ax.com>
sandy_lucca_at_yahoo.com (Sandy) wrote:
>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
Why are you using an ORDER BY or ROWNUM in an update statement?
What are you attempting to accomplish? Received on Tue Aug 10 2004 - 17:54:23 CEST