Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - What Is a Transaction
(Continued from previous topic...)
What Is a Transaction?
A transaction is a logical unit of work requested by a user to be applied to the database objects.
Oracle server introduces the transaction concept to allow users to group one or more SQL statements
into a single transaction, so that the effects of all the SQL statements in a transaction can
be either all committed (applied to the database) or all rolled back (undone from the
(Continued on next topic...)
- What Is a Transaction?
- How To Start a New Transaction?
- How To End the Current Transaction?
- How To Create a Test Table for Transaction Testing?
- How To Commit the Current Transaction?
- How To Rollback the Current Transaction?
- What Happens to the Current Transaction If a DDL Statement Is Executed?
- What Happens to the Current Transaction If the Session Is Ended?
- What Happens to the Current Transaction If the Session Is Killed?
- How Does Oracle Handle Read Consistency?
- What Is a READ WRITE Transaction?
- What Is a READ ONLY Transaction?
- How To Set a Transaction To Be READ ONLY?
- What Are the Restrictions in a READ ONLY Transaction?
- What Are the General Rules on Data Consistency?
- What Are Transaction Isolation Levels Supported by Oracle?
- What Is a Data Lock?
- How Data Locks Are Respected?
- How To Experiment a Data Lock?
- How To View Existing Locks on the Database?
- What Is a Dead Lock?
- How Oracle Handles Dead Locks?