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