事务何时开始、何时结束？显式的事务控制? 隐式的事务发生
[@more@]-- 事务何时开始、何时结束？
When Does a Transaction Start and End?
A transaction begins when the first DML statement is encountered and ends when one of the following occurs:
A COMMIT or ROLLBACK statement is issued
A DDL statement, such as CREATE, is issued
A DCL statement is issued,such as grant,is issued
The user exits iSQL*Plus
A machine fails or the system crashes
-- 显式的事务控制
Explicit Transaction Control Statements
COMMIT, SAVEPOINT, and ROLLBACK
SAVEPOINT SAVEPOINT_name
ROLLBACK TO SAVEPOINT_name
-- 隐式的事务发生
Implicit Transaction Processing
(Automatic commit): DDL statement or DCL statement is issued. iSQL*Plus exited normally, without explicitly issuing COMMIT or ROLLBACK commands.
(Automatic rollback): Abnormal termination of iSQL*Plus or system failure.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271063/viewspace-908951/ ，如需转载，请注明出处，否则将追究法律责任。
