Home  >  Article  >  Database  >  Oracle 回滚演示 rollback演示

Oracle 回滚演示 rollback演示

WBOY
WBOYOriginal
2016-06-07 17:05:14837browse

SQLgt; lock table state in exclusive mode; Table(s) Locked. SQLgt; insert into state(state_cd,state_name) values (

Oracle 回滚演示 rollback演示

[日期:2011-09-25] 来源:Linux社区  作者:huzia [字体:]

插入以后可以看到数据,

但是回滚以后,就回到插入以前的状态了,

把回滚前插入的数据取消了。

rollback命令执行之后,

给state表加的锁就自动解开了。

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn