title: Oracle Same Query return Different Result on Different Connection (Uncommit Transaction)
body: <p>I have 2 oracle Connections using <strong>same Query</strong> but returning different results :</p>
  <pre><code>SELECT TO_CHAR(DATE_TIME, 'yyyy-MM-dd hh:mi:ss' ) myDateTime,
  t.*
  FROM TMI_ISD_AUDIT_TRAIL t
  WHERE NVL(USER_ID,'') LIKE '%'
  AND NVL(Action,'') LIKE '%'
  AND NVL(success,'') LIKE '%%'
  AND TO_CHAR(DATE_TIME, 'yyyy-MM-dd' ) LIKE '%'
  AND rownum &lt;100
  </code></pre>
  <p>Query return 1 row
  <a href="https://i.stack.imgur.com/MlPEQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MlPEQ.png" alt="enter image description here" /></a></p>
  <p>Query return 2 row
  <a href="https://i.stack.imgur.com/Nwr0e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Nwr0e.png" alt="enter image description here" /></a></p>
  <p>Connection 1 IP :
  <a href="https://i.stack.imgur.com/kDt0S.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kDt0S.jpg" alt="enter image description here" /></a>
  Connection 2 IP :
  <a href="https://i.stack.imgur.com/lRjGs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lRjGs.jpg" alt="enter image description here" /></a></p>
  <p>How to check underlying uncommitted transaction?</p>