Re: Locking on insert

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Tue, 23 Mar 2004 20:11:41 +0800
Message-ID: <4060297D.373C@yahoo.co.uk>

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

-- 
-------------------------------
Connor McDonald
http://www.oracledba.co.uk
Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"

Received on Tue Mar 23 2004 - 06:11:41 CST