Re: Lock Table

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 08 Sep 2005 13:28:25 -0700
Message-ID: <1126211259.436309@yasure>

xhoster_at_gmail.com wrote:
> 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

Can you write a simple demo that demonstrates blocking a reader? I can see how to block an insert, update, or delete, but not a select.

Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Sep 08 2005 - 15:28:25 CDT