Oracle SQL Developer Tutorial For Beginners 41 Demo of a Transaction

Now let me show you the demonstration of the transactions. First I have logged in as the user TST. Then I am going to create a Table called TST.EMPLOYEE. Created. Now, Transaction 1, which inserting Tom’s info. Done Verified. Committed. Transaction 1 is done. Now on to Transaction 2. Insert Scott’s info. Done. Verified and committed. Now to Transaction 3. Modify both the values. I should not do a commit in between. That’s the key. Verify and Commit. Transaction 3 is done. Thank you for watching this video.

Leave a Reply

Your email address will not be published. Required fields are marked *