top of page
CerebroSQL

Oracle:

COMMIT

COMMIT [ WORK ]
[ [ COMMENT string ]
| [ WRITE [ WAIT | NOWAIT ] [ IMMEDIATE | BATCH ]
]
| FORCE string [, integer ]
] ;

example

INSERT INTO regions VALUES (5, 'Antarctica');
COMMIT WORK;

COMMIT WRITE BATCH;

COMMIT COMMENT 'In-doubt transaction Code 36, Call (415) 555-2637';

COMMIT FORCE '22.57.53';

bottom of page