Data manipulation language

DMLData Manipulation Language (DML)manipulation DMLdata manipulationquery languages
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.wikipedia
56 Related Articles

SQL

Structured Query LanguageSQL databaseSQL Databases
A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.
Originally based upon relational algebra and tuple relational calculus, SQL consists of many types of statements, which may be informally classed as sublanguages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML).

Database

database management systemdatabasesDBMS
A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.

Select (SQL)

SELECTSQL query keyword
The SQL-data change statements are a subset of the SQL-data statements; this also contains the SELECT query statement, which strictly speaking is part of the DQL, not the DML.
In most applications, is the most commonly used data manipulation language (DML) command.

Sublanguage

A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language.
SQL (Structured Query Language) statements are classified in various ways, which can be grouped into sublanguages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML).

Query language

querydatabase query languageData query language
Read-only selecting of data is sometimes distinguished as being part of a separate data query language (DQL), but it is closely related and sometimes also considered a component of a DML; some operators may perform both selecting (reading) and writing.

CODASYL

Conference on Data System LanguagesCodasyl database specifications
Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.
This specification in fact defined several separate languages: a data definition language (DDL) to define the schema of the database, another DDL to create one or more subschemas defining application views of the database; and a data manipulation language (DML) defining verbs for embedding in the COBOL programming language to request and update data in the database.

Data definition language

DDLdata definitionCREATE
Manipulation of persistent database objects, e.g., tables or stored procedures, via the SQL schema statements, rather than the data stored within them, is considered to be part of a separate data definition language (DDL).
Some forms of CREATE TABLE DDL may incorporate DML (data manipulation language)-like constructs, such as the CREATE TABLE AS SELECT (CTAS) syntax of SQL.

PL/SQL

PLSQLMetatranz StepSqlitePL/SQL (Oracle)
Examples of these are Oracle's PL/SQL and DB2's SQL_PL.
While programmers can readily embed Data Manipulation Language (DML) statements directly into PL/SQL code using straightforward SQL statements, Data Definition Language (DDL) requires more complex "Dynamic SQL" statements in the PL/SQL code.

Programming language

programming languageslanguagedialect
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.

Data

statistical datascientific datadatum
A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.

Relational database

relational database management systemRDBMSrelational databases
A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.

IBM Information Management System

IMSInformation Management SystemHierarchical Sequential Access Method
Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.

IDMS

CA IDMS
Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.

Database schema

schemarelational schemaschemas
In SQL, the data manipulation language comprises the SQL-data change statements, which modify stored data but not the schema or database objects.

Stored procedure

stored proceduresproceduresdatabase procedures
Manipulation of persistent database objects, e.g., tables or stored procedures, via the SQL schema statements, rather than the data stored within them, is considered to be part of a separate data definition language (DDL).

Verb

verbssubject-verb agreementv.
Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb.

Imperative programming

imperativeimperative programming languageimperative language
Most SQL database implementations extend their SQL capabilities by providing imperative, i.e. procedural languages.

Oracle Database

OracleOracle RDBMSOracle 10g
Examples of these are Oracle's PL/SQL and DB2's SQL_PL.

IBM Db2 Family

DB2IBM DB2pureQuery
Examples of these are Oracle's PL/SQL and DB2's SQL_PL.

American National Standards Institute

ANSIAmerican Standards AssociationAmerican National Standard
There have been a number of standards established for SQL by ANSI, but vendors still provide their own extensions to the standard while not implementing the entire standard.

Procedural programming

proceduralprocedural languageprocedural code
Data manipulation languages are divided into two types, procedural programming and declarative programming.

Declarative programming

declarativedeclarative languagedeclarative programming language
Data manipulation languages are divided into two types, procedural programming and declarative programming.

Computer program

programprogramscomputer programs
Data manipulation languages were initially only used within computer programs, but with the advent of SQL have come to be used interactively by database administrators.