SQL - Data Manipulation Language (DML)

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

1 - About

Data Manipulation Language (DML) is a category of SQL statement that modify the data of a database.

The principal commands are:

but you can also find:

  • MERGE performs a combination of insert, update and/or delete statements in one single statement
  • CALL to call a PL/SQL or Java subprogram
  • LOCK TABLE to control the concurrency behaviour

3 - Implicit

Implicit DML is a mechanism where DML are automatically performed by object such as:

as a side effect of a principal DML