How To End the Current Transaction
Q
How To End the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management
✍: 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.
2007-04-18, 4868👍, 0💬
Related Topics:
