Re: Select not locked rows

Anatoly Moskovsky wrote:
>
> Hi!
>
> Is it possible to select for update only not locked rows?
> If not, how can I detect if a row has been locked?
>

SELECT ... WHERE ... FOR UPDATE NOWAIT

-- 
Uwe Schneider - WEB.DE AG - Amalienbadstr. 41 - 76227 Karlsruhe 
Forschung & Entwicklung - Tel. (+49) 721 94329 832
"In a world without walls and fences, who needs windows and gates?"