In this chapter, you will learn
What a cursor is
How to use cursors inside SQL procedures
How to perform positioned deletes and positioned updates
How cursors affect locking
About cursor behavior on commit and rollback
How to use nested save points
How cursors are used to return result sets to applications.
In previous chapters, you have seen how SQL procedures can manipulate table data by directly executing
DELETE statements. Using SQL in this manner, however, means that operations must be applied to the entire set of data defined by the
WHERE clause of the statement. In SQL procedures, it is possible to define a set of data rows (which will be called a result set from here ...