|
|
|
The End Transaction SQL statement terminates an in-progress multi-statement transaction (MST) and commit its updates, if any, to the database. This statement causes all database updates effected by the MST to become available to other user transactions. After committing an MST with END TRANSACTION, the MST is terminated, the MST can no longer be aborted, and all its savepoints are nullified.
This statement has the following format:
END TRANSACTION
|
|
|
The following example begins an MST, executes some SQL statements, and commits the updates to the database:
begin transaction;
insert into emp (name, sal, bdate)
values ('Jones,Bill', 10000, 1914);
insert into emp (name, sal, bdate)
values ('Smith,Stan', 20000, 1948);
end transaction; \g/* commits new rows to table */