Oracle_Savepoint_Rollback1
 
 

 

 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;