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

3 votes267 views2 answers
How to start postgresql on windows
SQL
4 votes297 views1 answer
Rename stored procedure in sql server
SQL
1 vote293 views1 answer
Mysql login console
SQL
0 vote260 views1 answer
How should I pass a table name into a stored proc?
SQL
7 votes251 views1 answer
Forge server hosting
SQL
2 votes268 views1 answer
Oracle convert run_duration to number
SQL
8 votes285 views1 answer
Ltrim sql
SQL
0 vote306 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
2 votes257 views1 answer
Query to find table size in oracle 12c
SQL
2 votes253 views2 answers
Postgres set user as superuser
SQL