transaction

Thread view:

Enable EMail Alerts

Start New Thread

asanam.85@gmail.com - 28 Mar 2007 09:38 GMT

when we dont commit in oracle wat happens whether it wil fetch
previous record

Reply to this Message

usenetuser@hotmail.co.uk - 28 Mar 2007 10:25 GMT

On Mar 28, 9:38 am, "asanam...@gmail.com" <asanam...@gmail.com> wrote:

> when we dont commit in oracle wat happens whether it wil fetch
> previous record

This is comp.lang.*java*.programmer. You may be better off asking
this OT question in an Oracle newsgroup.

However, if by fetch you mean SELECT after a modification using UPDATE/
DELETE/INSERT, but prior to COMMIT, the subsequent SELECT will return
the modified record *as long as you are within the same session/
transaction*. All other sessions/transactions will show the
unmodified records (or block) until the COMMIT occurs.

Reply to this Message

Lew - 28 Mar 2007 12:55 GMT

> On Mar 28, 9:38 am, "asanam...@gmail.com" <asanam...@gmail.com> wrote:
>> when we dont commit in oracle wat happens whether it wil fetch
[quoted text clipped - 8 lines]
> transaction*. All other sessions/transactions will show the
> unmodified records (or block) until the COMMIT occurs.

It can actually get more complicated depending on how concurrent accesses
interleave with COMMITs. The bottom line is the same though: until transaction
"A" commits then transaction "B" cannot (reliably) see the results.

The complications arise from the interactions between, say, DELETEs and
INSERTs, and from effects of the four different levels of transaction isolation.

-- Lew

Reply to this Message

transaction

Free Magazines