COMMIT
Save changes (transactional).
Syntax:
COMMIT [WORK] [COMMENT 'comment_text'] COMMIT [WORK] [FORCE 'force_text' [,int] ]
FORCE - will manually commit an in-doubt distributed
transaction
force_text - transaction identifier (see the DBA_2PC_PENDING
view)
int - sets a specific SCN
If a network or machine failure prevents a distributed transaction from committing
properly, Oracle will store any commit comment in the data dictionary along
with the transaction ID.
Commit comments are likely to be depracated in a future
version of Oracle.
"Success is a lousy teacher. It seduces smart people into thinking they can't
lose." - Bill
Gates
Related Commands:
LOCK TABLE
SAVEPOINT - Save changes to a point
ROLLBACK - undo changes
SET TRANSACTION
Related Views:
DBA_2PC_PENDING V$TRANSACTION V$TRANSACTION_ENQUEUE
Equivalent SQL Server command:
