General MySQL Oracle SQL Server

Ways to End the Current Transaction in Oracle

Q

How To End the Current Transaction in Oracle?

✍: FYIcenter.com

A

There are several ways the current transaction can be ended:

  • Running the COMMIT statement will explicitly end the current transaction.
  • Running the ROLLBACK statement will explicitly end the current transaction.
  • Running any DDL statement will implicitly end the current transaction.
  • Disconnecting a user session will implicitly end the current transaction.
  • Killing a user session will implicitly end the current transaction.

 

⇒ Create a Test Table for Transaction Testing in Oracle

⇐ Ways to Start a New Transaction in Oracle

⇑ Understanding SQL Transaction Management in Oracle

⇑⇑ Oracle Database Tutorials

2019-09-04, 2907🔥, 0💬

General MySQL Oracle SQL Server