Name
END
-- Ends the current transaction block and finalizes its modifications.
Synopsis
END [ WORK | TRANSACTION ]
Parameters
- WORK, TRANSACTION
These are both optional keywords. Neither have any effect.
Results
- COMMIT
This message is displayed if the transaction is successfully committed.
- NOTICE: COMMIT: no transaction in progress
This message is displayed if there is no transaction in progress for the END command to end.
Description
The END command is a synonym for COMMIT.
Use it to end transactions the same way you would use the COMMIT command.
Examples
The following example demonstrates how to commit a transaction with the END
command.
END WORK;