SQL - Data Manipulation Language (DML)

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

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap