Re: Locking on insert

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 23 Mar 2004 13:16:20 -0800
Message-ID: <1080076556.253509@yasure>

Connor McDonald wrote:

> Matthew Keene wrote:
>

>>"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<8vN7c.60968$1p.1003888_at_attbi_s54>...
>>
>>>What version of Oracle? In 9i there is an "upsert" functionality (see merge)
>>>Jim
>>
>>Oops, sorry, I meant to specify in the original post that this was
>>8.1.7 and therefore merge functionality was not available.

>
>
> You can synthesize this with dbms_lock
>
> hth
> connor

Would you have a demo you could send me?

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Mar 23 2004 - 15:16:20 CST