Simple data manipulation is a programming technique used to
SELECT or INSERT a single row. It can also be used to
INSERT, DELETE, or UPDATE one or more rows based on a specific
criterion. These types of data manipulation operations are
considered simple because they can be done with SQL data
manipulation commands that:
Are not executed in conjunction with a cursor. Therefore
additional SQL commands such as FETCH and OPEN are not required.
Are not dynamically preprocessed. Therefore the amount of code
required to execute them is minimized.
This chapter reviews how to use the SELECT, INSERT, DELETE, and
UPDATE commands for simple data manipulation. It then examines
transaction management considerations that are relevant to
simple data manipulation. Finally, this chapter examines two
programs that illustrate simple data manipulation.