TRANSACTIONAL CONTROL LANGUAGE Commands | Database Concepts in Tamil
HTML-код
- Опубликовано: 17 окт 2024
- TCL Commands | Database concepts in Tamil | #11
In this video we are going to discuss the following questions
---------------------------
TCL Commands
---------------------------
The COMMIT command is used to permanently save any transaction to the database.
When any DML commands like INSERT, UPDATE, DELETE commands are used, the changes made by these commands are not permanent.
It is marked permanent only after the COMMIT command is given from the SQL prompt.
Once the COMMIT command is given, the changes made cannot be rolled back.
The COMMIT command is used as
COMMIT;
ROLLBACK command
The ROLLBACK command restores the database to the last commited state.
It is used with SAVEPOINT command to jump to a particular savepoint location.
The syntax for the ROLLBACK command is :
ROLL BACK TO save point name;
SAVEPOINT command
The SAVEPOINT command is used to temporarily save a transaction so that you can rollback to the point whenever required.
The different states of our table can be saved at anytime using different names and the rollback to that state can be done using the ROLLBACK command.
SAVEPOINT savepoint_name;
Example showing COMMIT, SAVEPOINT and ROLLBACK in the student table having the following data:
****************************************************************************
RUclips - / @sriramasubramaniamnag...
Connect me @
instagram: / sriramasubramaniam
sololearn: www.sololearn....
PlayList:
C programming - • C Programming Language
Python Programming - • Python Programming
Python programs - • Python programs
DataBase Concepts - • DataBase Concepts
canva - www.canva.com/...
#DatabaseConceptsinTamil
Give work examples bro.. For beginners it will be helpful
Bro. How to become a begineer and intermediate and advanced python freelancer. Please bro video podunga🙏🙏🙏🙏🙏