Re: Lock Table

DA Morgan <damorgan_at_psoug.org> wrote:
> AnySQL (d.c.b.a) wrote:
> > you can change you sql to select (1) from my_table for update, else
> > oracle will never block reader.
> >
> >
> > ANYSQL from china
> > http://www.anysql.net/en/
>
> It is impossible, in Oracle, to block a reader? Where are you getting
> your information?

"Select...for update" reads things. "Select...for update" blocks. Hence, it is possible to block a reader.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB