RE: Oracle 11G Upgrade
From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Fri, 28 Mar 2014 08:52:04 -0500 (CDT)
Message-ID: <b13405ef54637e871f51b0050c96529e.squirrel_at_society.servebeer.com>
> 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.
Date: Fri, 28 Mar 2014 08:52:04 -0500 (CDT)
Message-ID: <b13405ef54637e871f51b0050c96529e.squirrel_at_society.servebeer.com>
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 28 2014 - 14:52:04 CET