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
SQL Tutorial, Data Manipulation
Concepts of the Database System, Locks for Database Objects