Transaction Control Statements
COMMIT
COMMIT;Makes changes permanent.
ROLLBACK
ROLLBACK;Undoes changes since the last COMMIT.
SAVEPOINT
SAVEPOINT point1;
-- Some DML
ROLLBACK TO point1; COMMIT;Makes changes permanent.
ROLLBACK;Undoes changes since the last COMMIT.
SAVEPOINT point1;
-- Some DML
ROLLBACK TO point1;