Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

atomicity

525458Aug 14 2006 — edited Aug 14 2006

Hello,

Oracle maintains atomicity.

I want to know at what condition it maintain automatic atomicity.

I have one example

Sql> Update xyz

set emp_no=12
where emp_no=16; This happens successfully.

Sql>Update xyz

set emp_no=12
where emp_no=16; this fails.

These two statement make my one transaction; as staements (2) fails, how does it maintain atomicity.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2006

Added on Aug 14 2006

#general-database-discussions

4 comments

520 views