Oracle中事务的提交commit和回滚rollback及保存点savepoint

根据上篇BLOG中创建的表,学生信息表studentinfo请参考上篇文章

INSERT INTO STUDENTINFO VALUES('017','SMITH',0,'19-9月-88','北京市怀柔区');
INSERT INTO STUDENTINFO VALUES('018','SMITH LEE',0,'25-11月-86','上海市松江区');
--SAVEPOINT sp1;
INSERT INTO STUDENTINFO VALUES('019','SMITH LEE',0,'25-11月-86','上海市松江区');
--SELECT * FROM STUDENTINFO ;
--ROLLBACK TO sp1;
COMMIT;