Data manipulation statements

The statements you use to add, change, or delete data are called data manipulation statements, which are a subset of the data manipulation language (DML) statements part of ANSI SQL. The main DML statements are:

INSERT statement Adds new rows to a table or view.
UPDATE statement The UPDATE statement changes rows in a set of tables or views.
DELETE statement The DELETE statement removes rows from a set of tables or views.
MERGE statement The MERGE statement adds, changes, and removes specific rows from a table or view.

In addition to the statements above, the LOAD TABLE and TRUNCATE TABLE statements are especially useful for bulk loading and deleting of data.

Data manipulation statements

See also