Rollback to in sql

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

Commit in sql

• COMMIT —> making all pending changes permanent;
• SAVEPOINT name —> marks a save point
• 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 to in sql

• ROLLBACK TO name —> rolls back changes to savepoint

Similar codes

3 votes100 views2 answers
To_char oracle
SQL
0 vote103 views1 answer
Convert rows into columns in oracle
SQL
7 votes108 views5 answers
Show details of table postgres
SQL
0 vote97 views1 answer
Mysql workbench indent formatting
SQL
0 vote199 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
1 vote92 views4 answers
Between vs in sql
SQL
2 votes113 views1 answer
Sql finding longest and shortest names in a fleld
SQL
10 votes109 views1 answer
All_dependencies
SQL
2 votes113 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
3 votes61 views1 answer
System.debug apex
SQL