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.

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-l
Received on Fri Mar 28 2014 - 14:52:04 CET

Original text of this message