Committing and Rolling Back Changes

Commit and Rollback

If data manipulation statement complete and if no error occurred, database modifications through embedded insert, update, and delete statements must be committed. This is done by using the following SQL statement

COMMIT;

If an error occurred and previous non-committed data modifications need to be undone, the embedded SQL statement

ROLLBACK;

Note:

Do it yourself

Update employee Shawn Adams and change the HIREDATE value to April 1, 2001.
Then commit the changes.
Retrive the record to observe the change.
Update same employee and change the HIREDATE value to April 2, 2001.
Rollback and retriev the record