B. SQL Statements from Earlier Releases : End Transaction Statement : Example: End Transaction
 
Share this page                  
Example: 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 */