----》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