Re: upsert strategies?
Date: Wed, 12 Nov 2008 19:30:12 +0100
> So far, I've figured out 4 possible ways to perform upsert-like
> 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!
Search asktom.oracle.com for "upsert" - he has documented, timed examples of why you should use merge
-- Regards, Frank van BortelReceived on Wed Nov 12 2008 - 12:30:12 CST