Data Manipulation Language

Data Manipulation Language: Once the database is designed and database is populated with data, the data manipulation language (DML) is used to manipulate the database. In data manipulation, data is retrieved, inserted, updated and deleted to and from the database. It must be noted that DDL is not used for data manipulation.

The application programmer can insert the DML statements into the program written in general purpose language. Whenever, DML statements embedded in a general purpose programming language that language is called the Host Language and the DML is called Data Sub Language.