Data Manipulation Language (DML)

Rumman Ansari   Software Engineer   2023-03-23   15543 Share
☰ Table of Contents

Table of Content:


The DBMS provides data manipulation language (DML) that enables users to retrieve and manipulate the data. The statement that is used to retrieve the information is called a query. The part of the DML used to retrieve the information is called a query language. The DML are of two types, namely, non-procedural DML and procedural DML. The non-procedural or high-level or declarative DML requires a user to specify what data are required without specifying how to retrieve the required data. For example, SQL (Structured Query Language) is a non-procedural query language. The procedural or low-level DML requires the user to specify what data are required and how to access that data by providing a step-by-step procedure. For example, relational algebra is a procedural query language.

Here are some tasks that come under DML:

  • Select: It is used to retrieve data from a database.
  • Insert: It is used to insert data into a table.
  • Update: It is used to update existing data within a table.
  • Delete: It is used to delete all records from a table.
  • Merge: It performs UPSERT operation, i.e., insert or update operations.
  • Call: It is used to call a structured query language or a Java subprogram.
  • Explain Plan: It has the parameter of explaining data.
  • Lock Table: It controls concurrency.