oracle中rollback的使用

----》rollback使用
sql> create table tbl(name varchar2(10));

table created.

sql> insert into tbl values('zhiqiao');

1 row created.

sql> select * from tbl;

name
----------
zhiqiao

sql> delete tbl;

1 row deleted.

sql> select * from tbl;

no rows selected

sql> rollback;

rollback complete.

----》没有提交(commit)的数据删除后无法rollback
sql> select * from tbl;

no rows selected

sql> insert into tbl values('zhiqiao');

1 row created.

sql> select * from tbl;

name
----------
zhiqiao

sql> commit;

commit complete.

sql> delete tbl;

1 row deleted.

sql> select * from tbl;

no rows selected

sql> rollback;

rollback complete.

----》提交(commit)了的数据删除后可以使用rollback恢复
sql> select * from tbl;

name
----------
zhiqiao

sql> delete tbl;

1 row deleted.

sql> commit;

commit complete.

sql> rollback;

rollback complete.

----》删除数据后提交(commit)则无法使用rollback恢复
sql> select * from tbl;

no rows selected