Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle COMMIT Statement      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: COMMIT

Definition:
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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 71 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?