Re: Setting Dirty Reads or No Lock for SELECT

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 30 May 2001 23:32:17 +0200
Message-ID: <thapj116uq3024@beta-news.demon.nl>

"Lau, Wayne" <WLau_at_Collegeboard.org> wrote in message news:C3E31780D570D4119FBF00B0D0208309B52ADE_at_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...
>
>
> - Wayne
>
>
>
>
>
>
> --
> Posted from cb4nyo.collegeboard.org [207.122.6.3]
> via Mailgate.ORG Server - http://www.Mailgate.ORG

select doesn't lock your table.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed May 30 2001 - 16:32:17 CDT