Example: INSERT Request
The INSERT request in the following example opens the transaction. COMMIT closes the transaction.
INSERT INTO employee (name, empno) VALUES ('Sinclair P', 101) WHERE dept = '400'; COMMIT;
Example: UPDATE Followed By COMMIT
The following UPDATE initiates the transaction and COMMIT WORK terminates it:
UPDATE parts SET part_num = 20555 WHERE location = 'seoul'; COMMIT WORK;