.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

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, 4840👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML