Results 1 to 3 of 3

Thread: Transaction in Oracle Server

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    64

    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?


  2. #2
    Junior Member
    Join Date
    Oct 2006
    Answers
    24

    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.


  3. #3
    Contributing Member
    Join Date
    May 2006
    Answers
    64

    Re: Transaction in Oracle Server

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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact