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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is it possible to use nolock type of hint in query

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

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 10 Aug 2006 13:41:05 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A20127A0F1@EXCHANGE.corp.perceptron.com>


Thank god (actually - thank oracle), there is no such hint in oracle.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Thursday, August 10, 2006 1:32 PM
To: ORACLE-L
Subject: Is it possible to use nolock type of hint in query

Hi,

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?

Thanks
--Harvinder

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 10 2006 - 12:41:05 CDT

Original text of this message

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