upsert strategies?

From: <mh_at_pixar.com>
Date: Sun, 26 Oct 2008 06:44:57 GMT
Message-ID: <JlUMk.3915$D32.1708@flpi146.ffdc.sbc.com>


So far, I've figured out 4 possible ways to perform upsert-like functionality:

  1. try insert, on exception update
  2. try update, on exception insert
  3. delete, then insert
  4. merge with DUAL

It seems so far the nicest solution is #4.

Here's some questions:

  • Do the other methods have any features which might recommend them?
  • Are there any methods that might be portable to other databases?
  • Are there any methods I might be overlooking?

Many TIA!
Mark

-- 
Mark Harrison
Pixar Animation Studios
Received on Sun Oct 26 2008 - 01:44:57 CDT

Original text of this message