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>
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:
- try insert, on exception update
- try update, on exception insert
- delete, then insert
- 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 StudiosReceived on Sun Oct 26 2008 - 01:44:57 CDT