SQL TCL Commands- Transaction Control Language

SQL TCL Commands- Transaction Control Language 

TUTORIAL IN HINDI:

Download

COMMIT –  This SQL TCL command will commit the running transaction

SYNTAX:

COMMIT;

EXAMPLE:  

DELETE FROM STUDENT  

WHERE ID = 25;  

COMMIT;

-----------------------------------------------------------------------------------------

ROLLBACK – Rollback the current transaction.

SYNTAX:

ROLLBACK;  

DELETE FROM STUDENT  

WHERE ID = 25;  

EXAMPLE:

ROLLBACK;

--------------------------------------------------------------------------------------------

SAVEPOINT – You can set a save point so that, next time it will start from here.

SYNTAX:

SAVEPOINT SAVEPOINT_NAME; 

--------------------------------------------------------------------------------------------

SQL:

• The Structured Query Language (SQL) is the language of databases.
• All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building block.
• In fact, it’s often the only way that you can truly interact with the database itself.
• All of the fancy graphical user interfaces that provide data entry and manipulation functionality are nothing more than SQL translators.
• They take the actions you perform graphically and convert them to SQL commands understood by the database.
• SQL is Similar to English
• Fortunately, at its core, SQL is a simple language.
• It has a limited number of commands and those commands are very readable and are almost structured like English sentences.

SQL Commands:

SQL commands are instructions. It is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data.

Types of SQL Commands:

DDL:

DML:

DQL:

DCL:

TCL:

Follow Us :-

YouTube: