What wrong with such query:

update MY_TABLE
set FIELD_ONE = 'A'
where FIELD_TWO in (select FIELD_TWO
from MY_TABLE
where rownum < 11
order by FIELD_THREE )

The query return such error:
ORA-00907: missing right parenthesis

I know that the problem because of the "order by" but why?

And if I need to update only specify portion (for example first 10 records)
what to do?
I can use PL/SQL , cursor , but can I do using single query?

Thanks

The select clause doesn't return the result as you are expecting.
The "ORDER" logic is applied AFTER 10 records is retrieved from MY_TABLE.

So there is no way to use 1 simple SQL to complete your operation.

Wing

"Jul" <julia.sats (AT) sympatico (DOT) ca> ¦b¶l¥ó
news:Nr26d.4808$MD5.395214 (AT) news20 (DOT) bellglobal.com ¤¤¼¶¼g...