Re: Select not locked rows

Hi Anatoly

if you want to select the unlocked rows you could do it like this:

select *
  from z
    for update nowait
   skip locked;

bye

Roger

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful