1
Reply

What is transaction control statement and how many types of transaction control statement in Oracle?

Sapna Malik

Sapna Malik

13y
3.5k
0
Reply

    The transaction control commands allow the user to manage database transactions. Four types of transaction control command in Oracle:

    1. COMMIT Saves database transactions.
    2. ROLLBACK Undoes database transactions.
    3. SAVEPOINT Creates points within groups of transactions in which to ROLLBACK.
    4. SET TRANSACTION Places a name on a transaction.