If we have used the UPDATE command to make some changes into the database, and realise that those changes were not required, then we can use the ROLLBACK command to rollback those changes, if they were not commited using the COMMIT command.įollowing is rollback command's syntax, ROLLBACK TO savepoint_name SAVEPOINT command It is also used with SAVEPOINT command to jump to a savepoint in an ongoing transaction. This command restores the database to last commited state. To avoid that, we use the COMMIT command to mark the changes as permanent.įollowing is commit command's syntax, COMMIT ROLLBACK command When we use any DML command like INSERT, UPDATE or DELETE, the changes made by these commands are not permanent, until the current session is closed, the changes made by these commands can be rolled back. COMMIT commandĬOMMIT command is used to permanently save any transaction into the database. It also allows statements to be grouped together into logical transactions. These are used to manage the changes made to the data in a table by DML statements. Transaction Control Language(TCL) commands are used to manage transactions in the database.īefore moving forward with TCL commands, check these topics out first:

ER Model: Generalization and Specialization.

Roll back java update