There are basically 6 types of SQL statements.
They are as follows
a) Data Definition Language(DDL)- The DDL statements define and maintain objects and drop objects.
b) Data Manipulation Language(DML)- The DML statements manipulate database data.
c) Transaction Control Statements- Manage change by DML
d) Session Control- Used to control the properties of the current session enabling and disabling roles and changing
e.g- Alter Statements, Set Role
e) System Control Statements- Change Properties of Oracle Instance e.g- Alter System
f) Embedded SQL- Incorporate DDL, DML, and T.C.S in Programming Language. e.g:: Using the SQL Statements in languages such as 'C', Open, Fetch, execute, and close