SQL - Data Manipulation Language (DML)

Data System Architecture

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

Implicit

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

as a side effect of a principal DML





Discover More
Data System Architecture
Data - Transaction (Trans(versal?) actions)

A single logical operation on the data is called a transaction. A physical operation is called a request and therefore a transaction is a queue of request. For example, a transfer of funds from one bank...
Card Puncher Data Processing
Glossary

(CREATE, ALTER, DROP) (GRANT, REVOKE) (SELECT, UPDATE, INSERT, DELETE) (COMMIT, ROLLBACK) NLS (National Language Support) UDML is the abbreviation for Universal Database Markup Language ...
Bi Server Architecture With Client
OBIEE 10G/11G - persist connection pool

A persist connection pool is a database property that is used for specific types of queries (typically used to support Marketing queries). In some queries, all of the logical query cannot be sent to...
Owb Mapping Operating Mode
OWB - Operating Mode (of a Mapping or Workflow)

A mapping and a workflow runs with a operating mode: Set-based (SQL) Row-based (PL/SQL) Set-based Fail Over to Row-based (If Sql failed, go to PL/SQL) Set-based Fail Over to Row-based Target Only...
Card Puncher Data Processing
Oracle Database - Compression

By using a data compression algorithm specifically designed for relational data, Oracle is able to compress data much more effectively than standard compression techniques. More significantly, unlike other...
Card Puncher Data Processing
Oracle Database - Distributed Transactions

A distributed database is a set of databases in a distributed system that can appear to applications as a single data source. A distributed transaction is a transaction that includes one or more statements...
Card Puncher Data Processing
Oracle Database - Explain Plan

EXPLAIN PLAN is an Oracle SQL Command that tell you what the query plan for a given SQL would be : if executed it right now in the current session with the current settings For this purpose, it...
Card Puncher Data Processing
Oracle Database - FOREIGN KEY Constraints

A foreign key is a referential constraint between two tables. The foreign key identifies: a column or a set of columns in one (Child/dependent) table that refers to set of columns in another...
Oracle Database Lock Foreign Key Unindexed
Oracle Database - Locks and Foreign Keys - Concurrency control of parent keys

Oracle Database maximizes the concurrency control of parent keys in relation to dependent foreign keys. Locking behaviour depends on whether foreign key columns are indexed. If foreign keys are not indexed,...
Card Puncher Data Processing
Oracle Database - Parallel DML

To enable parallelization of Data Manipulation Language (DML) statements such as INSERT, UPDATE, and DELETE , see this article How to enable parallelization ? The following rules apply when determining...



Share this page:
Follow us:
Task Runner