Re: merge and ORA-30926
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Fri, 26 Sep 2014 07:57:01 +0100
Message-ID: <DUB402-EAS427A1F196F4D195F512B8A2A1BF0_at_phx.gbl>
From previous observations, I believe the error is raised if both source rows would actually change the value of the same target row. It's a little bit unsatisfactory and inconsistent (e.g. Change behaviour with an order by)
Date: Fri, 26 Sep 2014 07:57:01 +0100
Message-ID: <DUB402-EAS427A1F196F4D195F512B8A2A1BF0_at_phx.gbl>
From previous observations, I believe the error is raised if both source rows would actually change the value of the same target row. It's a little bit unsatisfactory and inconsistent (e.g. Change behaviour with an order by)
http://orastory.wordpress.com/2011/10/13/merge-oddity/
>
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^
Received on Fri Sep 26 2014 - 08:57:01 CEST