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

Can we rollback in sql

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

Rollback in sql

ROLLBACK;		-- instead of commit

Rollback to in sql

• ROLLBACK TO name —> rolls back changes to savepoint

Similar codes

2 votes103 views1 answer
Oracle list duplicates
SQL
0 vote122 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
8 votes100 views2 answers
Change name of colum in sql table
SQL
1 vote100 views1 answer
Update and replace mysql
SQL
3 votes100 views2 answers
How to load files in mysql
SQL
0 vote94 views1 answer
View acl table oracle
SQL
0 vote95 views2 answers
Update all linkedserver tables with openquery on db
SQL
2 votes107 views2 answers
How to add not null constraint in sql
SQL
20 votes119 views6 answers
Creating a table in sql
SQL
0 vote95 views1 answer
C# mysql data reader from two tables
SQL