Re: Changing isolation level?

While stranded on information super highway ctcgag_at_hotmail.com wrote:
:)NoJunkMailshah_at_xnet.com wrote:
:)
:)(Pertaining to using select for update to voluntarily be blocked by
:)>writers)
:)>
:)> This will not work.
:)>
:)> I have to read the next row to find out what it is and then delete it.
:)
:)What do you mean "next row". You want to skip the one that's locked?
:)Does DB2 or whatever do this? I would think they just block on the one
:)that's locked, not skip it.

 In DB2 if the row is a part of a result set it will be skipped.  If I execute SELECT on the specific row then I will be blocked, and wait  until the row is commited.

 In Oracle I will always get the old value in SELECT.

:)
:)> If another process has already deleted the row, I should be getting the
:)> old value.
:)
:)Are you using "should" to describe what you desire, or what you think is
:)going on?

  Oops. the above statement is incorrect. I should say I should NOT be getting   the old value".

:)
:)> Oracle will not block readers.
:)
:)Unless the readers ask for it.

  No. I will never block readers.

:)
:)Xho
:)
:)--
:)-------------------- http://NewsReader.Com/ --------------------
:)Usenet Newsgroup Service New Rate! $9.95/Month 50GB

-- 
Hemant Shah                           /"\  ASCII ribbon campaign
E-mail: NoJunkMailshah_at_xnet.com       \ /  --------------------- 
                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.           
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.