Full row duplicate update

General

Full row duplicate update

Can we update a single row of two full row duplicate records. In this below scenario if I want to update the Location of the 2nd record to Spain, then how should I do it. I think its imposible to update like this. I tried to mark these two row with row_number function but its updating both(I used volatile table concept).

 ID_N     NAME    LOCATION

 4           TRES       Brazil

 4           TRES       Brazil

Thanks,

Banerjee

1 REPLY

Re: Full row duplicate update

No, you cannot (you can try a workaround though).

Note that your table is not even in 1FN!

Cheers.

Carlos.