Data Manipulation Language (DML)

Data Manipulation Language (or DML) consists of SQL statements used to retrieve, insert, update and delete records from database tables. DML statements are the only statements that can be rolled back or recovered.

• DELETE

  Deletes specified rows from a table. Also has a special format (DELETE WHERE CURRENT OF) for embedded SQL.

• INSERT

  Inserts a specified number of rows into a table.

• SELECT

  Retrieves data from one or more tables. Also has a special format (SELECT INTO) for embedded SQL.

• UPDATE

  Modifies data in specified rows of a table. Also has a special format (UPDATE WHERE CURRENT OF) for embedded SQL.