Data manipulation language overview

<< Click to Display Table of Contents >>

Navigation:  Local SQL > Data Manipulation Language >

Data manipulation language overview

 Previous pageReturn to chapter overviewNext page

 

The Data Manipulation Language (DML) part of local SQL consists of the following language elements.

Category                Description

 

Statements        Statements, or commands, that retrieve, modify, and delete data.
Clauses        Clauses of statements that affect how a statement operates.
Functions        Functions like UPPER that alter data and SUM that aggregate data.
Operators        Arithmetic, comparison, logical, and string concatenation operators.
Predicates        Keywords used in WHERE clauses to qualify rows returned by a statement.
Relational operators        Operators that allow joining multiple tables.
Updatable queries        Conditions under which queries are updateable or read-only.
Parameters in queries        Using parameters to make queries dynamic.
Local SQL VIEWs        The local SQL emulation of SQL VIEWs.