rollback command in sql code example
Example 1: rollback in sql
ROLLBACK; -- recover datas back to previous commit in current session
Example 2: rollback in sql
DELETE clause is from DML,
we can use ROLLBACK to recover the data.
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint
Example 3: can we rollback in sql
es, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.
Example 4: rollback to in sql
• ROLLBACK TO name —> rolls back changes to savepoint