oracle中rollback的使用

oracle

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