Data Manipulation Language:

The Data Manipulation Language or DML is one of the database language which enables users to Access or Manipulate data of an organized Data Model. Through DML Retrieve Data, Insert Data, Delete data and Modify the Data.

DML is of two types Procedural DML and Declarative DML.

Procedural DML: It requires an user to specify what data are needed and how to get those data.
Declarative DML: It is also known as non procedural DML which requires an user to specify what data are needed without specifying how to get those data.
DML component of SQL language is Non Procedural.

A query is a statement requesting to perform any of the DML operation like Retrieval, Insertion etc. And portion of a DML that involves Information retrieval is called Query Language.

Eg: Select Customer.Customer-Name From Customer Where Customer.Customer-id=192-83-7465

This query in the SQL language find them whose Customer-id is 192-83-7465
** This Query language depends upon the which database management system that is software we are using. Every DBMS has only little change in their SQL language.

Facebook Likes