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

8 votes178 views1 answer
Oracle tablespace datafile max size
SQL
0 vote148 views1 answer
Teller stamp , bmo , PDF
SQL
7 votes158 views1 answer
Buy forge mods server hosting
SQL
0 vote146 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote160 views2 answers
How to create a table from another table in sql derby
SQL
0 vote175 views1 answer
The fetch keyword oracle
SQL
1 vote171 views1 answer
Myql find duplicates
SQL
0 vote191 views1 answer
Mysql last friday of current month
SQL
16 votes175 views2 answers
Sql vs nosql
SQL
0 vote155 views1 answer
Mysql streaming example
SQL