Re: upsert strategies?

mh_at_pixar.com wrote:
> 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
>

Search asktom.oracle.com for "upsert" - he has documented, timed examples of why you should use merge

-- 

Regards,
Frank van Bortel