TCL ( Transaction Control Language )
The TCL full form is Transaction Control Language commands are used to run the changes made by the DML commands And one more thing is TCL can be grouped into a logical transaction. And We have two different commands in this category below I listed them for reference.
- Commit It is used for save the transaction on the Database. And these very useful in banking sectors.
- Rollback It is used for restore the database to original state from last commit. This command also plays an important role in Banking Sectors.
Now I will explain these two commands for your reference. And I provide proper examples below I provide those example
Commit
The Commit command is used for save the transaction in the database and changes are made by the DML statements. Now I will provide the example below Here I used ClassMembers Table. Here I inserted a new data into Table then I commit It.
Syntax:
Database Operation
Commit
Example:
ROLLBACK
Rollback command is used for restore the database to original state from last commit. Here I provide the example and in this I already commit the you can see in the above, Now I delete one row from the Table then again rollback the previous database state.
Syntax:
ROLLBACK;
Example:
Conclusion
In this article I will explained Database Languages In Database which are used for different purposes. We have DDL, DCL, DML, TCL these are different categories. The DDL language is used for used for define the database internal structure and Pattern of the Database. And the DCL commands are used to control the data from the user means It can provide control on the Database, Table and Data. The DML commands are used to manipulate the Data in Table like Inserting, updating, deleting of the Data finally the TCL commands are used to save and restore the previous state of Database.
Database Languages in DBMS
Databases are used to store information. The Database is related to both software and hardware here The Software is used for accessing the data in the form of Software applications, and The Hardware is used for storing the data in the memory or hard disk.
Any Database provides an interface between the end user and the database by using this interface, the end user can access the database data. It is a very secure means before accessing database data we need to authenticate first, and then we get access to the database. We have different types of Database Languages which are represented in the below image.