Codd's Twelve Rules - Rule 7 - High level Insert, Update, and Delete

Codd's Twelve Rules - Rule 7 - High level Insert, Update, and Delete

Rule 7	High level Insert, Update, and Delete
Rule	The capability of handling a base relation or a derived relation as a single operand applies not only to the retrieval of data but also to the insertion, update, and deletion of data.
Description	This rule stresses the set-oriented nature of a relational database. It requires that rows be treated as sets in insert, delete, and update operations. The rule is designed to prohibit implementations that support only row-at-a-time, navigational modification of the database. The SQL language covers this via the INSERT, UPDATE, and DELETE statements.
Example	SQL Server,          MySQL, and Oracle support bulk insert, delete, and update.           INSERT INTO yourtable VALUES (1,2), (5,5), ...; - this can be used to insert multiple rows at a time in MySQL.
Some DBMS that fulfills this property	SQL Server,          MySQL, and Oracle

Go to Home - Codd's Twelve Rules