SQL - Data Manipulation Language (DML)


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


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

as a side effect of a principal DML

Powered by ComboStrap