RE: Is it possible to use nolock type of hint in query

The example I heard in a presentation about SQL Server isolation levels was an airline seat reservation system: you wouldn't consider as available a seat that had been reserved by another session, whether committed or not. Dubious, probably just a way to cast SQL Server's inferior read consistency model in a positive light, but there it is.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still Sent: Thursday, August 10, 2006 3:20 PM
To: Harvinder.Singh_at_metratech.com
Cc: ORACLE-L
Subject: Re: Is it possible to use nolock type of hint in query

On 8/10/06, Harvinder Singh < Harvinder.Singh_at_metratech.com <mailto:Harvinder.Singh_at_metratech.com> > wrote:

In sql server we can use nolock hint to see the uncommitted data of the other sessions. Is their any equivalent hint for query in Oracle?

I'm curious why you would want to see uncommited changes from another transaction.

What action can you possibly take based on data that may or may not be committed at some point in the future.?

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist





==============================================================================

Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


==============================================================================



--
http://www.freelists.org/webpage/oracle-l