Re: Oracle 11G Upgrade
- From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
- To: "rjoralist3@xxxxxxxxxxxxxxxxxxxxx" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 28 Mar 2014 14:04:30 +0000
"Update else insert" behaves differently than "insert else update" under
concurrent activity.
Similarly merge is different again.
http://orastory.wordpress.com/2011/10/13/concurrent-merge
Cheers,
Dominic
Sent from my iPhone
On 28 Mar 2014, at 13:53, "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx> wrote:
>> Jack, have you considered just changing the logic to perform the update
>> first and check the cursor count number of rows updated. If zero perform
>> the insert.
>
> An INSERT, followed by an UPDATE on fail should be more efficient. I can't
> remember where I saw that years ago (asktom?), but my own testing confirmed
> it in some older version of Oracle (9 or 10).
>
> I was thinking along the same lines though and wondering if a MERGE
> statement in place of the INSERT/UPDATE would work...
>
> Rich
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
