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;