Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with selecting/updating rows

Re: Problem with selecting/updating rows

From: Neil Hulin <nospam_at_litech.freeserve.co.uk>
Date: Mon, 9 Nov 1998 22:36:46 -0000
Message-ID: <727r2m$7e8$1@newsreader1.core.theplanet.net> 





There is no way to prevent another user from "seeing" any row that has been
committed to the database. This is the whole concept of consistent view. If
you need to ensure sequentiality (good word, hey) without failing the second
user's transaction, use "select ... for update nowait".



...neil [actually: neil.hulin_at_litech.freeserve.co.uk]




Received on Mon Nov 09 1998 - 16:36:46 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US