PL/SQL TCL COMMANDS

PL/SQL Transaction

You can use the COMMIT, ROLLBACK, SAVEPOINT, and SET TRANSACTION command to control the transaction.

1. COMMIT : COMMIT command to make changes permanent save to a database during the current transaction.
2. ROLLBACK : ROLLBACK command execute at the end of current transaction and undo/undone any changes made since the begin transaction.
3. SAVEPOINT : SAVEPOINT command save the current point with the unique name in the processing of a transaction.
4. AUTOCOMMIT : Set AUTOCOMMIT ON to execute COMMIT Statement automatically.
5. SET TRANSACTION : PL/SQL SET TRANSACTION command set the transaction properties such as read-write/read only access.