Re: Locking Problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 2 Mar 1999 21:03:02 -0000
Message-ID: <920409422.28099.2.nnrp-12.9e984b29@news.demon.co.uk>

You might consider changing your pseudonym, Only the rows meeting the WHERE clause are locked.

--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

I have a spelling chequer
It came with my pea sea
It plainly marques for my revue
Miss steaks eye cannot sea

I've run this poem threw it
I'm shore your pleased to no
Its letter perfect in it's weigh
My chequer tolled me so

Oracleguru, Suresh Bhat wrote in message <01be64e6$fc38f740$a504fa80_at_mndnet>...
>Hi
>
>You don't say whether you use a cursor to do the transactions.
>
>If you are not using cursor, then your update statement probably looks like
>this:
>
> update table1 set x = ....
> where .........
>
>then the entire table is locked.
>
Received on Tue Mar 02 1999 - 15:03:02 CST