title: Dirty read in Oracle - how to read uncommitted record
body: <p>In SQL Server, let's say I am testing a functionality, I can apply a breakpoint in app and check the uncommitted records in DB like this:</p>
  
  <pre><code>select * from mytable with(nolock)
  </code></pre>
  
  <p>Is there an equivalent dirty read available in Oracle., As far as I can see, I am unable to find such a feature.</p>
  
  <p><a href="http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm#CNCPT1322" rel="nofollow">Here it says it's not possible</a> at all. From debugging a core issue perspective, is there some way to achieve this ?</p>