Re: Update a Unique Row

From: Emmanuel <zouzou_at_yahoo.com>
Date: 14 Jan 2000 15:39:09 GMT
Message-ID: <01bf5eae$55b7e9e0$3601017e@EHM.cirra.fr>

add the condition

WHERE ROWNUM=1 in your update query.

jeanch_at_my-deja.com a écrit dans l'article <85neah$v4j$1_at_nnrp1.deja.com>...
> Hi folks,
>
> I have got in the table tab_A two entries ent_1 and ent_2 that are
> identical; I want to be able to update only one (ent_1)
> of those and leave the other entry (ent_2) untouched;
> Does anybody knows how to do it please ?
> Thanks for your help.
> Cheers
> JC
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Fri Jan 14 2000 - 09:39:09 CST