9  DML

Data Manipulation Language (DML)

Data Manipulation Language (DML)

Data Manipulation Language (DML) deals with data manipulation to store, insert, modify, delete and update data in database

• SQL commands: INSERT, UPDATE, MERGE, DELETE, COMMIT, ROLLBACK, SAVEPOINT.

• Value expressions

• Predicates

• Logical connectives

• Set functions: Math, String, Date Aggregate functions