Firing explicit and implicit commits : Rollback Commit « PL SQL Statements « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Statements
  3. Rollback Commit
SQL>
SQL> --An Explicit Commit


begin
   update ...;
   update ...;
   insert ...
   commit;
end;








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