Oracle_Savepoint_Rollback1
 
Oracle performs an auto commit for a DDL statement execution, therefore a rollback statement will not remove a table created with "CREATE TABLE ..."  statement.

During a transaction, simple rollback will erase the data during that process. Oracle provides some finer "ROLLLBACK"  with "SAVEPOINT" statement; the save point operation moves the pointer a designated location, then rollback to a save point will flash-back the cursor to this location.

Please Review This Reference :
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/sqloperations.htm#BABGAAIG

 

 INSERT INTO S1(eid, fname, lname, address)
VALUES (14, 'Basant','Desai', 'Address 5');
SAVEPOINT SP1;
INSERT INTO S1(eid, fname, lname, address)
VALUES (15, 'Pratap','Singh', 'Address 6');
ROLLBACK TO SAVEPOINT SP1;
INSERT INTO S1(eid, fname, lname, address)
VALUES (16, 'Sanjeeva','Reddy', 'Address 7');
-- ORACLE AUTOCOMMIT OFF THEN
COMMIT;