Implicit commits : Rollback Commit « PL SQL Statements « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Statements
  3. Rollback Commit

Implicit commits fire automatically when you use any DDL commands that create, alter, or delete any database objects.

An implicit commit is also executed when you send a request to terminate a session in any one of a number of ways, such as using the EXIT command in SQL*Plus or closing your connection.









22.13.Rollback Commit
22.13.1.Adding a Partial Rollback
22.13.2.Use rollback in PL/SQL
22.13.3.Roll back in exception handler
22.13.4.Implicit commits
22.13.5.A Full, Explicit Rollback
22.13.6.Firing explicit and implicit commits