Update question
From: Jul <julia.sats_at_sympatico.ca>
Date: Mon, 27 Sep 2004 20:42:17 -0400
Message-ID: <Nr26d.4808$MD5.395214_at_news20.bellglobal.com>
What wrong with such query:
Date: Mon, 27 Sep 2004 20:42:17 -0400
Message-ID: <Nr26d.4808$MD5.395214_at_news20.bellglobal.com>
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?
Thanks
Received on Tue Sep 28 2004 - 02:42:17 CEST
I can use PL/SQL , cursor , but can I do using single query?