Rollback Oracle

SQL> savepoint in_author;

Punto de grabacion creado.

SQL> insert into employee values('4','GOD','Xesar','Palerta')
2 ;

1 fila creada.

SQL> select * from employee;

EMP_NO JOB_GRADE EMP_NAME EMP_SNAME
-- ---- ---- ----
1 BOFH David Aniones
2 BOSS Ramon Monina
3 MANAGER Onin Onionhood
4 GOD Xesar Palerta

SQL> rollback to in_author;

Rollback terminado.

SQL> select * from employee;

EMP_NO JOB_GRADE EMP_NAME EMP_SNAME
-- ---- ---- ----
1 BOFH David Aniones
2 BOSS Ramon Monina
3 MANAGER Onin Onionhood

SQL>