commit command permanently changes the data in the database.
By default, automatic commit for DML commands is off. The automatic commit for DML commands can be set by using the following command
SET AUTOCOMMIT ON; -- and to turn it off SET AUTOCOMMIT OFF;
ROLLBACK [TO SAVEPOINT < savepoint_name>];
SAVEPOINT < savepoint_name >;