Start transaction, commit and rollback syntaxStart Transaction | Begin [Work]commit [Work] [and [No] chain] [[No] release]rollback [work] [and [No] chain] [[No] release]set autocommit = { 0 | The 1}start transaction or BEGIN statement can begin a
Error Handling of nested transactions and transaction retention points
For nested transactions.1. Start external transactions, start internal transactions, and try catchInternal error: if an internal transaction error occurs, internal and
BEGIN TRANSACTIONMarks the starting point for an explicit local transaction. BEGIN TRANSACTION The @ @TRANCOUNT by 1 increments.BEGIN TRANSACTION represents a point where data referenced by a connection is logically and physically consistent at that
Start transaction,COMMIT, AndROLLBACKSyntax
From: http://dev.mysql.com/doc/refman/5.0/en/commit.html
Of course, the article noted from MySQL, but MySQL, SQL Server, Oracle start tracmsaction, commit, and rollback syntax are no problem in DML.
I hope
From the point of view of database programming, a database luw is an inseparable sequence of database operations that ends with a database commit. the database luw is either fully executed by the database system or not at all. once a database luw
With the large number of high-concurrency access, massive data processing and other scenarios more and more, how to achieve the high availability of web sites, scalability, scalability, security and other goals are becoming more and more important.
(1). insufficient space for rollback segments
ORA-01562-failed to extend rollback segment number string
The reason for insufficient rollback segment space is generally as follows:
A. The remaining free space in the tablespace where the rollback
Undo tablespace and rollback segments
The Undo/rollback tablespace is the tablespace used to store rollback segments. The rollback segment is the data space of the image before Oracle saves the modified data. Each rollback segment contains some
triggers cannot invoke or indirectly invoke a DCL statement such as Commit,rollbackDDL statements and Commit,rollback statements cannot be run in triggersDDL statements: DDL statement terms define and manage objects in the database, such as
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.