SQL - Data Manipulation Language (DML)

About

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

The principal commands are:

• SELECT
• UPDATE,
• INSERT,
• and DELETE

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
• EXPLAIN PLAN
• LOCK TABLE to control the concurrency behaviour

Articles Related

Implicit

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

• integrity constraints,
• remote procedure calls,
• and triggers

as a side effect of a principal DML