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

Home -> Community -> Usenet -> c.d.o.server -> Setting Dirty Reads or No Lock for SELECT

Setting Dirty Reads or No Lock for SELECT

From: Lau, Wayne <WLau_at_Collegeboard.org>
Date: Wed, 30 May 2001 19:50:43 +0000 (UTC)
Message-ID: <C3E31780D570D4119FBF00B0D0208309B52ADE@RO> 






How can you indicate to the SELECT statement to not put a lock on a table
while you are reading from it.  This is important for me when doing long
queries on an Oracle database.  DB2 had a "WITH UR" option and SQL Server
has a "NO LOCK" option.  Sorry for the novice question, but just started to
use Oracle.  Doh!  Thanks.  Later...






-- 
Posted from cb4nyo.collegeboard.org [207.122.6.3] 
via Mailgate.ORG Server - http://www.Mailgate.ORG


Received on Wed May 30 2001 - 14:50:43 CDT












Original text of this message













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