GNU/Linux |
RedHat 6.2(Zoot) |
|
commit(l) |
COMMIT − Commits the current transaction
COMMIT [ WORK | TRANSACTION ]
INPUTS
WORK |
TRANSACTION
Optional keywords. They have no effect.
OUTPUTS
END |
Message returned if the transaction is successfully committed. |
NOTICE EndTransactionBlock and not inprogress/abort state
If there is no transaction in progress.
COMMIT commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.
NOTES
The keywords WORK and TRANSACTION are noise and can be
omitted.
Use rollback(l) to abort a transaction.
To make all changes permanent:
COMMIT WORK;
SQL92
Full compatibility.
commit(l) |