Use of rollback in Oracle

Oracle

----"Rollback use
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.

----cannot be rollback without commit (commit) data deletion
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" data deletion can be used for rollback recovery
Sql> select * from TBL;

NAME
----------
Zhiqiao

sql> Delete tbl;

1 row deleted.

Sql> commit;

Commit complete.

sql> rollback;

Rollback complete.

----"commit (commit) after deleting data cannot use rollback recovery
Sql> select * from TBL;

No rows selected