|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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:
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