1• COMMIT —> making all pending changes permanent;
2• SAVEPOINT name —> marks a save point
3• ROLLBACK —> discharges all pending changes to prev commit
4• ROLLBACK TO name —> rolls back changes to savepoint
1 COMMIT —> making all pending changes permanent;
2• SAVEPOINT name —> marks a save point
3• ROLLBACK —> discharges all pending changes to prev commit
4• ROLLBACK TO name —> rolls back changes to savepoint
5
1DELETE clause is from DML,
2we can use ROLLBACK to recover the data.
3• ROLLBACK —> discharges all pending changes to prev commit
4• ROLLBACK TO name —> rolls back changes to savepoint