Chinaunix首页 | 论坛 | 博客
  • 博客访问: 88959
  • 博文数量: 37
  • 博客积分: 2000
  • 博客等级: 大尉
  • 技术积分: 386
  • 用 户 组: 普通用户
  • 注册时间: 2009-11-11 11:33
文章分类

全部博文(37)

文章存档

2011年(1)

2010年(30)

2009年(6)

我的朋友

分类: LINUX

2010-03-10 11:22:09

以下信息来自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) |
给主人留下些什么吧!~~