SAVEPOINT

savepoint를 통해 해당 상태를 기억해놨다가 rollback to 명령어를 통해 해당 savepoint로 돌아갈 수 있음

SELECT * FROM teltable;
INSERT INTO teltable VALUES(999, '손흥민', '010-7777-7777', sysdate);
SAVEPOINT point1;

INSERT INTO teltable VALUES(777, '메시', '010-1010-1010', sysdate);
SAVEPOINT point2;

UPDATE teltable SET NAME='박찬호' WHERE id=2;
SAVEPOINT point3;

INSERT INTO teltable VALUES(888, '호날두', '010-1010-1010', sysdate);
ROLLBACK TO point3;