In Oracle, COMMIT
statement is used to commits all changes into the database table for the current transaction. Once committed, the committed changes is than available for other users.
To commits all changes into the database table, use the following syntax:
Parameters:
WORK: COMMIT with or without the WORK parameter will result in the same outcome.
COMMENT: This is optional. It is used to specify a comment to be associated with the current transaction.
WRITE : It is used to specify the priority that the redo information for the committed transaction is to be written to the redo log.
FORCE : It is used to force the commit of a transaction that may be corrupt or in doubt.
Note:
In the above example shows that how to issue a commit in Oracle using the COMMIT statement.
Note:
In the above example shows that how to use the COMMENT clause with COMMIT.