10일차 # 8-27: COMMIT, ROLLBACK, SAVEPOINT

 drop table t1 purge;

  create table t1 (col1 number);

  insert into t1 values (1000);

  insert into t1 values (3000);

  insert into t1 values (2500);

  savepoint s1;

  insert into t1 values (2000);

  insert into t1 values (4200);

  savepoint s2;

  insert into t1 values (1800);

  insert into t1 values (2200);

  

  rollback to s1;

  insert into t1 values (3800);

  insert into t1 values (2900);

  commit;