Use Commit and Rollback Commands.

Commit:

 

SQL> select *
2 from publisher;
NAME ADDRESS PHONE
--------------- -------------------- ----------
AJ PUBLISHER Kulai Mangalore 9472308100
AB Book Company Mangalore 9632587412
Ram Publishers Bangalore 9874563215
Raj Books Shringeri 8542658965
Hanuman Books Puttur DK 9458547562
SQL> insert into publisher
2 values('Guru Publisher','Sakaleshpur','9856475214');
1 row created.
SQL> commit;
Commit complete.
SQL> select *
2 from publisher;
NAME ADDRESS PHONE
--------------- -------------------- ----------
AJ PUBLISHER Kulai Mangalore 9472308100
AB Book Company Mangalore 9632587412
Ram Publishers Bangalore 9874563215
Raj Books Shringeri 8542658965
Hanuman Books Puttur DK 9458547562
Guru Publisher Sakaleshpur 9856475214
6 rows selected

 

Rollback:

 

SQL> select *
2 from publisher;
NAME ADDRESS PHONE
--------------- -------------------- ----------
AJ PUBLISHER Kulai Mangalore 9472308100
AB Book Company Mangalore 9632587412
Ram Publishers Bangalore 9874563215
Raj Books Shringeri 8542658965
Hanuman Books Puttur DK 9458547562
Guru Publisher Sakaleshpur 9856475214
6 rows selected.
SQL> delete from publisher
2 where name='Guru Publisher';
1 row deleted.
SQL> select *
2 from publisher;
NAME ADDRESS PHONE
--------------- -------------------- ----------
AJ PUBLISHER Kulai Mangalore 9472308100
AB Book Company Mangalore 9632587412
Ram Publishers Bangalore 9874563215
Raj Books Shringeri 8542658965
Hanuman Books Puttur DK 9458547562
SQL> rollback;
Rollback complete.

SQL> select *
2 from publisher;
NAME ADDRESS PHONE
--------------- -------------------- ----------
AJ PUBLISHER Kulai Mangalore 9472308100
AB Book Company Mangalore 9632587412
Ram Publishers Bangalore 9874563215
Raj Books Shringeri 8542658965
Hanuman Books Puttur DK 9458547562
Guru Publisher Sakaleshpur 9856475214
6 rows selected.