Data Manipulation Language (DML)
Data Manipulation Language (DML)
Data Manipulation Language (DML) is used for data manipulation.
Data manipulation is
Retrieval of Information Stored in Database
Insertion of Information to the database
Deletion of information from the database
Updating of information stored in the databas
Types of Data Manipulation Language (DML)
Procedural DML
Declarative DML (Non Procedural DML)
Procedural DML:
In procedural Data manipulation language user has to specify what data are needed and how to get it.
Declarative DML (Non Procedural DML):
In declarative Data manipulation language user has to specify what data are needed without specifying how to get it.
Example : SQL (Structured Query Languages)