Geeks Talk

Prepare for your Next Interview




Transaction in Oracle Server

This is a discussion on Transaction in Oracle Server within the Oracle forums, part of the Databases category; In the Oracle Server, what are the things that will happen when we commit a transaction? Can we still undo what we have committed already?...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 06-01-2006
Contributing Member
 
Join Date: May 2006
Posts: 66
Thanks: 1
Thanked 5 Times in 4 Posts
janelyn is on a distinguished road
Transaction in Oracle Server

In the Oracle Server, what are the things that will happen when we commit a transaction? Can we still undo what we have committed already?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 10-02-2006
Junior Member
 
Join Date: Oct 2006
Location: india
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
parthokonar1 is on a distinguished road
Re: Transaction in Oracle Server

When you update the Oracle Server in some way, that update should initially be regarded as tentative only - tentative in the sense that, if something subsequently goes wrong, the update may be undone. Updates remain tentative until an SQL COMMIT or SQL ROLLBACK statement is executed. The SQL COMMIT statement makes all tentative updates firm or committed. Once committed, an update is guaranteed never to be undone.
Reply With Quote
  #3 (permalink)  
Old 10-13-2006
Contributing Member
 
Join Date: May 2006
Posts: 66
Thanks: 1
Thanked 5 Times in 4 Posts
janelyn is on a distinguished road
Re: Transaction in Oracle Server

Yes you are right. Thanks for your update.I even tried a example for my understanding.
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Oracle Interview Questions Free E-Book admin Downloads 277 1 Week Ago 02:16 AM
What is Oracle Net Services GeekAdmin Oracle 2 02-15-2007 06:02 AM
What are the New Application Frameworks in SQL Server 2005 admin Testing Issues 1 05-30-2006 07:07 PM
ADO.NET new Features in SQL Server 2005 admin Testing Issues 0 05-29-2006 07:05 PM
Explain about SMO in SQL Server 2005 admin Testing Issues 0 05-29-2006 06:56 PM


All times are GMT -4. The time now is 05:25 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved