Rollback to in sql

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

Commit in sql

• COMMIT —> making all pending changes permanent;
• SAVEPOINT name —> marks a save point
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint

Can we rollback in sql

es, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.

Rollback to in sql

• ROLLBACK TO name —> rolls back changes to savepoint

Similar codes

1 vote160 views1 answer
How to unlock table in mysql
SQL
0 vote175 views1 answer
How to map sql column to custom names
SQL
2 votes145 views1 answer
Sqlplus clear screen
SQL
0 vote158 views1 answer
Price-colour
SQL
0 vote146 views1 answer
Mysql calculated column
SQL
0 vote151 views1 answer
Acual month sql
SQL
1 vote156 views1 answer
Backup mysql data only
SQL
4 votes132 views1 answer
Sql list users and roles
SQL
11 votes159 views6 answers
Distinct sql
SQL
0 vote150 views1 answer
Sql get count without group by
SQL