What is the difference between ROLLBACK and ROLLBACK TO statements?
Posted On: Dec 21, 2022
There is a considerable difference between the ROLLBACK and ROLLBACK TO statements. When you apply the ROLLBACK command a transaction is completely undone where all the blocks are released. As far as the ROLLBACK TO command is concerned, the transaction is undone but till a SAVEPOINT. Thus, the transaction remains live and active even after the command is implemented.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
PL/SQL Interview Questions
What is PL/SQL?
PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..
PL/SQL Interview Questions
Differentiate between PL/SQL and SQL?
PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..
PL/SQL Interview Questions
State few characteristics of PL/SQL?
Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..