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:

  • 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
Advertising

3 - 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

data/type/relation/sql/dml.txt · Last modified: 2017/09/13 16:15 by gerardnico