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;