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

6 votes119 views1 answer
Phpmyadmin reset root password
SQL
0 vote122 views1 answer
Oracle sql log to console
SQL
20 votes167 views4 answers
How to find average in sql
SQL
0 vote248 views1 answer
How to delete duplicate rows in oracle
SQL
11 votes132 views2 answers
MySQL DISTINCT
SQL
0 vote130 views1 answer
Mysql query to add hours to column in table
SQL
0 vote124 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
2 votes152 views1 answer
Laravel sql String
SQL
25 votes128 views6 answers
Import mysql database command line
SQL
-1 vote126 views1 answer
Ssql to lowercqse
SQL