COMMIT, ROLLBACK, SAVEPOINT

Published July 26, 2025 By Sai Sree Ram Gundepudi

Transaction Control Statements

COMMIT

COMMIT;

Makes changes permanent.

ROLLBACK

ROLLBACK;

Undoes changes since the last COMMIT.

SAVEPOINT

SAVEPOINT point1;
-- Some DML
ROLLBACK TO point1;

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article