Summary

In this chapter, you have seen the usage of the cursors in SQL procedures. Cursors allow you to access and process data one row at a time, giving you the opportunity to implement much more complex logic that would otherwise be impossible or difficult to carry out. When using cursors to process data, you can perform reads and positioned deletes/updates. You can use the cursor either to process the data within the SQL procedure, or to return result sets to the client program.