Mohamed Zaatar's Blog

All of us know the typical three types of SQL Statement which are (DML , DCL and DDL) but they are more categorization:

1- DDL (Data Definition Language)
like Create, Alter.

2- DML (Data Manipulation Language)
like insert , update , delete

3- DCL (Data Control Language)
like : Revoke , Grant

4- DQL (Data Query Language)
Like Select with all clauses.

5- TCL (Transactional Control Language):
like Commit , RollBack

6- System Control Statements
In SQL Server : Set XYZ_OPTION TRUE
in Oracle : only one statement : ALTER SYSTEM

7- Embedded SQL Statements: It is an embedded programming into sql but not a SQL Language but each Vendor implements it in his own way.

In SQL Server: CLR integration
In Oracle: Module