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
See also the commit_write and
commit_work initialization parameters.
|