以下信息来自ORACLE 9i 联机文档
A transaction ends when any of the following occurs:
事务结束的触发条件:
1.A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.
2.A user runs a DDL statement such as CREATE, DROP, RENAME, or ALTER. If the
current transaction contains any DML statements, Oracle first commits the
transaction, and then runs and commits the DDL statement as a new, single
statement transaction.
3.A user disconnects from Oracle. The current transaction is committed.
4.A user process terminates abnormally. The current transaction is rolled back.
After one transaction ends, the next executable SQL statement automatically starts the following transaction.
Note: Applications should always explicitly commit or undo
transactions before program termination.
阅读(785) | 评论(0) | 转发(0) |