Quick Search:
 The Oracle COMMIT Statement      [Return To Index] Jump to:  


The Oracle COMMIT statement makes permanent any changes made to the database during the current transaction.

When you execute the COMMIT statement in your database session, all changes made in your session (including all updated changes in workspaces that you have attached with read/write access) are committed. All committed changes are visible to other users who subsequently attach the workspace.

The SQL COMMIT statement can also be embedded as static SQL in a PL/SQL block.

If you want to change the result of a query that has affected rows or need to correct a mistake, you can use the ROLLBACK statement to reverse and undo the changes made by the COMMIT statement.

Oracle documentation recommends that you explicitly end every transaction with a COMMIT or ROLLBACK statement before disconnecting from Oracle Database.

Note that if you do not explicitly commit the transaction and the program terminates abnormally, then the last uncommitted transaction is automatically rolled back.

Example Syntax:

commit write <option>
commit write wait
commit write nowait
commit write batch
commit write immediate

Related Links:

Related Code Snippets:
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org