What is DML?

DML Stands for... Data Manipulation Language

• DML is a language of SQL, It will be supported by RDBMS System
• DML is helps to manipulate the data into relational database
• DML modify the stored data (not the structure of DB object) in the database
• DML is purely handling the data in the database in different ways like loading/removing/modifying the data in the database

Following SQL commands are part of DML

SELECT
SELECT ... INTO (It is exists in DDL & DML)
INSERT INTO
UPDATE
DELETE
TRUNCATE

Data manipulation languages are mainly classified as 2 type, procedural programming and declarative programming.

Procedural Programming : Collection of SQL Statements

Declarative Programming: The individual SQL statements are declarative