Re: How to UPDATE using ROWNUM and ORDER BY

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 - 10:54:23 CDT