Data Manipulation 

The following is an introduction to the data manipulation language (DML) used by the database system.

Every SQL statement for data manipulation implicitly sets a write lock for each inserted, updated, or deleted row.

SQL statements for data manipulation

INSERT statement	UPDATE statement	DELETE statement
NEXT STAMP statement	CALL Statement

Examples

SQL Tutorial, Data Manipulation

 

See also:

Concepts of the Database System, Locks for Database Objects