DDL, DML, DCL, and TCL

1. Overview

2. Description

2.1 Data Definition Language (DDL)

DDL is the short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

• CREATE – to create a database and its objects like (table, index, views, stored procedure, function, and triggers)
• ALTER – alters the structure of the existing database
• DROP – delete objects from the database
• TRUNCATE – remove all records from a table, including all spaces allocated for the records are removed
• COMMENT – add comments to the data dictionary
• RENAME – rename an object

2.2 Data Manipulation Language (DML)

DML is the short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such as SELECT, INSERT, UPDATE, DELETE, etc, and it is used to store, modify, retrieve, delete and update data in a database.

• SELECT – retrieve data from a database
• INSERT – insert data into a table
• UPDATE – updates existing data within a table
• DELETE – Delete all records from a database table
• MERGE – UPSERT operation (insert or update)
• CALL – call a PL/SQL or Java subprogram
• EXPLAIN PLAN – interpretation of the data access path
• LOCK TABLE – concurrency Control

2.3 Data Control Language (DCL)

DCL is the short name of Data Control Language which includes commands such as GRANT and mostly concerned with rights, permissions and other controls of the database system.

• GRANT – allow users access privileges to database
• REVOKE – withdraw users access privileges given by using the GRANT command

2.4 Transaction Control Language (TCL)

TCL is the short name of Transaction Control Language which deals with a transaction within a database.

• COMMIT – commits a Transaction
• ROLLBACK – rollback a transaction in case of any error occurs
• SAVEPOINT – to rollback the transaction making points within groups
• SET TRANSACTION – specify characteristics for the transaction

3. Reference

https://stackoverflow.com/questions/2578194/what-is-ddl-and-dml