Data Manipulation Language (DML)
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.