Lesson 26 : SAVEPOINT

SAVEPOINT

Savepoint  statement can be used to create a name (or marker) for a change (or any DML) in database. 

It can be used as a pointer within a transaction to which we can rollback the changes later

Syntax :

SAVEPOINT  <name >

Example :

SQL>  savepoint  step1 ;

Example :

SQL> insert into emp(empname) values (‘Mr Testing’);

SQL> savepoint step2;