Savepoint

From Oracle FAQ

A savepoint is a marker or point in an transaction to which you can later roll back.

Example

DELETE FROM dept WHERE deptno = 123;
SAVEPOINT step1;

INSERT NTO dept VALUES (123, 'Editors', Oracle FAQ');
SAVEPOINT step2;

ROLLBACK TO SAVEPOINT step1;
COMMIT;

Also see

• COMMIT
• ROLLBACK

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#