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

1 vote344 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote284 views1 answer
Big table in mysql
SQL
0 vote280 views1 answer
Regex mongoose
SQL
22 votes282 views4 answers
Tsql rename table
SQL
19 votes306 views3 answers
How to change column type psql
SQL
1 vote287 views1 answer
Oracle grant on all tables in schema
SQL
3 votes272 views2 answers
Mysql time
SQL
-1 vote305 views3 answers
My sql alter table
SQL
0 vote307 views1 answer
Mariadb set vertical output format
SQL
0 vote273 views2 answers
How to find max and min salary in sql
SQL