Re: Row and Table Locking

On Mon, 27 Aug 2001, graham.thornton_at_ln.ssw.abbott.com wrote:

> What you ideally need is optimistic locking with concurrency
> enabled. That is, if the row being updated has changed since
> you read from it, your write will be rejected. Unfortunately,
> Oracle does not support this feature as of 8.1.7.

Transaction isolation level of serializable should cover this scenario.

-- 
Galen Boyer
It seems to me, I remember every single thing I know.