René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

commit [Oracle SQL]

commit;
commit work;

commit comment 'some text';
commit force 'some text';
commit force 'some text' n;
n being an integer.
Commit ends a transaction and makes all changes of that transaction persistent.
There are two rules governing the use of commit in Oracle:
  • Commit as soon as you can, but
  • Don't commit earlier than you should.
See also the beauty of transactions.

Oracle 10g Release 2

Oracle 10g R2 enhances the commit:
commit write <option>
commit write wait
commit write nowait
commit write batch
commit write immediate
See also the commit_write and commit_work initialization parameters.