Savepoint of transactions in Oracle

Savepoint in Oracle transactions 1. Basic Concepts savepoint is a point in transactions and can be returned to a certain storage point through rollback. A transaction can have multiple storage points. Once the transaction is committed, the storage points in the transaction will be automatically deleted, no matter how many storage points have been done. Www.2cto.com SQL> savepoint sp; Savepoint created SQL> delete from mytable; 15 rows deleted SQL> rollback to sp; Rollback complete SQL> select count (*) from mytable; COUNT (*) ---------- 15 the delete operation is rolled back. Ii. explain several important operations of the transaction. 1. Set the storage point savepoint a. 2. cancel some transactions. rollback to a. 3. Cancel all transactions. If you execute SQL> commit, submit the operation, all the storage points in the transaction do not exist.
If you do not manually execute commit but exit, it is automatically submitted.