Re: Locks rows

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 22 Jan 2003 22:13:55 -0000
Message-ID: <3e2f23bb_1@mk-nntp-1.news.uk.worldonline.com>

"Francky" <fservantroumey_at_hotmail.com> wrote in message news:b0gl1d$119$1_at_news2.isdnet.net...
> Hello,
>
> Sorry for my bad english... I'm French
>
> I would like lock rows in table with a select instruction because i dont
> want that 2 user read simultaneous the data
>

Francky,

Don't worry about the English; it's fine.

There are ways of blocking other readers, even in Oracle. But I'm curious as to why you want to.

Why do you need to prevent multiple users selecting the data simultaneously? They will each (by default) see a read-committed view of the data as at the start of their query. Oracle is a multi-user database, after all.

Can you explain exactly what it is you are trying to achieve? Then we will be in a much better position to help.

Regards,
Paul Received on Wed Jan 22 2003 - 16:13:55 CST